home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ShareWare OnLine 2
/
ShareWare OnLine Volume 2 (CMS Software)(1993).iso
/
finance
/
p_mgr3.zip
/
MANUALS.EXE
/
MANUAL.DOC
next >
Wrap
Text File
|
1993-03-01
|
282KB
|
5,704 lines
Portfolio Manager Version 4.3
Copyright 1985-1993 by Shane Software International
Shane Software International
Steve Hane
107 17th Court
Sequim, WA. 98382
Order (only) line 800-742-6303 (1-800 SHANE 03)
Technical support 206-681-2402
CompuServe ID: 73060,2370
_______
____|__ | (tm)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
I N S T R U C T I O N M A N U A L
(some legal stuff)
Portfolio Manager is Copyrighted 1985-1993 by Shane Software
International and Steven C. Hane, and is protected by U.S.
domestic and international copyright laws.
ALL OF THE SHAREWARE AUTHOR'S RIGHT, TITLE AND INTEREST IN AND
TO THE SOFTWARE NOT EXPRESSLY GRANTED ARE RESERVED EXCLUSIVELY
BY THE AUTHOR."
Users of the Portfolio Manager must accept this disclaimer of
warranty: "Portfolio Manager is supplied as is. The author
disclaims all warranties, expressed or implied, including,
without limitation, the warranties of merchantability and of
fitness for any purpose. The author assumes no liability for
damages, direct or consequential, which may result from the
use of Portfolio Manager."
Please see "Legal considerations" at the end of this manual
PAGE I
T A B L E O F C O N T E N T S
CHAPTER 1: - GETTING STARTED
1.A Introduction .................................. 1
1.B About shareware ............................... 2
1.C Program description ........................... 3
1.C.a Unique features ........................ 4
1.C.b General information .................... 4
1.D Registration .................................. 5
1.E A short course in DOS ......................... 6
1.F Program installation .......................... 7
1.F.a Caution ................................ 7
1.F.b Preparation ............................ 7
1.F.c To start the install program ........... 8
1.F.d What will happen ....................... 8
1.F.e Install it yourself ???? ............... 9
1.F.f Important: (config.sys file) .......... 9
1.F.g In case of trouble (install) ........... 10
1.G Starting Portfolio Manager .................... 11
1.G.a The first time you use it .............. 11
1.H Starting YOUR data ............................ 12
1.H.a Quick start YOUR data .................. 12
1.H.b Starting YOUR data records ............. 13
1.H.c Ambitious start data entry ............. 13
1.I Creating and using sample data ................ 16
1.J Context sensitive HELP screens ................ 16
CHAPTER 2: - USING THE PROGRAM
2.0 General information ........................... 18
2.0.A The main menu .......................... 18
2.0.B The sub-menus .......................... 18
2.0.C Selecting accounts ..................... 19
2.0.D Creating hold (.HLD) files ............. 19
2.0.E Entering dates ......................... 21
2.0.F Editing entered data ................... 21
2.0.G Entering numeric data .................. 22
2.0.H Security selection ..................... 22
2.0.I Transaction remarks .................... 22
2.0.J Broker account during data entry ....... 23
2.1 EXIT MENU
2.1 General information ...................... 24
2.1.A Terminate the program .................... 24
2.1.B Review investment statistics ............. 25
2.1.C For technical assistance ................. 25
2.1.D Cancel entries this session .............. 27
2.1.E Create "HLD"; same as PM start ........... 28
2.1.F Info on program registration ............. 28
2.1.G Multiple portfolio manager ............... 29
PAGE II
T A B L E O F C O N T E N T S - (continued)
2.2 REPORT MENU
2.2 General information ...................... 30
2.2.A Reports 2 - 9 listed below ............... 32
2.2.B Investment purchase records .............. 33
2.2.C Current value of portfolio ............... 33
2.2.D Dividend & interest reports .............. 33
2.2.E Report on sold investments ............... 34
2.2.F Summary report of accounts ............... 35
2.2.G 1099 verify form (div/intr) .............. 35
2.2.H Return on investment (ROI) ............... 36
2.2.I Broker transactions report ............... 37
2.2.J Combined information report .............. 38
2.2.K Income history of one stock .............. 40
2.2.L Miscellaneous reports .................... 41
2.2.L.a IRS 1040 Support statement ...... 41
2.2.l.a.1 Print tax schedules B & D ... 41
2.2.l.a.2 Screen tax schedules B & D .. 42
2.2.L.b Maturity-CD's, Bonds, etc. ...... 42
2.2.L.c Display entered remarks ......... 42
2.2.L.d Show num & % of portfolio ....... 43
2.2.L.e Compare cost to value ........... 43
2.2.L.f Expand one selected stock ....... 43
2.2.L.g Print rept from disk file ....... 44
2.3 PURCHASE MENU
2.3 General information ...................... 45
2.3.A Enter a new investment ................... 45
2.3.A.a Constant value investments ...... 46
2.3.A.b Bond interest buy or sell ....... 48
2.3.B Add shares to stock you own .............. 48
2.3.C Enter stk split or stk div ............... 49
2.3.D Sell a stock short ....................... 49
2.3.E Cover short sale position ................ 49
2.3.F Adjust original cost basis ............... 50
2.3.G Adjust for merger or buyout .............. 50
2.4 UPDATE VALUES MENU
2.4 General information ...................... 51
2.4.A Quick Form - Full portfolio .............. 51
2.4.B Long Form - Full portfolio .............. 51
2.4.C Long Form - Select security ............. 51
2.5 INCOME MENU
2.5 General information ...................... 52
2.5.A Dividend income .......................... 53
2.5.B Interest income .......................... 54
2.5.C Return of Capital dividend ............... 54
PAGE III
T A B L E O F C O N T E N T S - (continued)
2.6 BROKER MENU
2.6 General information ...................... 55
2.6.A Debit broker cash account ................ 55
2.6.B Credit broker cash account ............... 55
2.6.C Review broker acct balance ............... 55
2.6.D Broker account with transactions ......... 56
2.7 SELL MENU
2.7 General information ...................... 57
2.7.A Sell an investment (all the shares) ...... 59
2.7.B Sell part of an investment ............... 59
2.7.C The treatment of bond interest ........... 61
2.7.D Covering short sale ...................... 61
2.8 MISCELLANEOUS MENU
2.8 General information ...................... 62
2.8.A Edit/Change/View a record ................ 62
2.8.B Delete an entry from records ............. 65
2.8.C Test & fix data &/or memory problem ...... 66
2.8.D Back data to a backup drive .............. 68
2.8.E Data from other years .................... 69
2.8.E.a Retrieve data from past year .... 70
2.8.E.b Restore data for CURRENT year ... 71
2.8.F Clear files for a new year ............... 72
2.8.G Recover back-ups ......................... 73
2.8.G.a From B/U made on start-up ....... 74
2.8.G.b From your B/U data disk ......... 74
2.8.G.c Select one file from B/U ........ 74
2.8.H Add/Delete/Rename an account ............. 75
2.8.H.a Create a new account ............ 76
2.8.H.b Delete existing account ......... 76
2.8.H.c Rename existing account ......... 76
2.8.H.d Transfer an account ............. 77
2.8.I CONFIGURE Portfolio Manager .............. 78
2.8.I.a Step thru 2 to E below .......... 79
2.8.I.b Color selection menu ............ 79
2.8.I.c Defined your accounts ........... 80
2.8.I.d Enter/change user name .......... 81
2.8.I.e Set a default response .......... 81
2.8.I.f Assign a backup drive ........... 82
2.8.I.g Numlock on/off- numeric ......... 82
2.8.I.h Set mouse sensitivity ........... 82
2.8.I.i Printer selection ............... 82
2.8.I.j Define report contents .......... 83
2.8.I.k Set cap gains period ............ 83
2.8.I.l Set the browse command .......... 83
2.8.I.m Automatic data testing .......... 84
2.8.I.n Set extra help screens .......... 85
2.8.I.o Clear all data files ............ 85
2.8.J Change name of an investment ............. 86
PAGE IV
T A B L E O F C O N T E N T S - (continued)
2.9 BONUS MENU
2.9 General information ...................... 87
2.9.A Calculator program ....................... 87
2.9.B Calendar program ......................... 88
2.9.C Financial calculations ................... 88
2.9.D Loan computations ........................ 88
CHAPTER 3: - THE OTHER STUFF
3.A Legal considerations .......................... 89
3.A.a Disclaimer ............................. 89
3.A.b Limited warranty ...................... 89
3.B License agreement ............................. 90
3.B.a Distribution restrictions .............. 91
3.B.b Vendor distribution authorization ...... 91
3.C Registration form ............................. 92
3.D In case of trouble ............................ 93
3.D.a Error files ............................ 93
3.D.b Abnormal program termination ........... 93
3.D.c Technical assistance ................... 95
3.E History of PM ................................. 96
3.E.a Special note to history ................ 99
3.F Glossary ...................................... 100
The manual will cross reference related features and
information using the appropriate Chapter and sub-chapter
numbers (ex. See Chapter 1, section 1.F.c)
PAGE 1
C H A P T E R 1: - G E T T I N G S T A R T E D
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1.A I N T R O D U C T I O N
~~~~~~~~~~~~~~~~~~~~~~~
Chapter 2 of this manual is organized in the sequence of the
menu options that appear in the main menu of the program.
Each menu item is shown in the table of contents and the
options available under that main menu feature are shown in
the order they appear in the sub-menu.
The program was designed to be intuitive in its use, however,
some options may be require additional explanation to follow
the logic I used for certain functions such as tracking a
savings account or a CD.
Throughout PM, context sensitive help screens are available
with the F1 Key. To activate a help screen you may press
the F1 at any point in the program. While the help screens
are active, you may enter the letter "T" (no quotes) to
activate a Topics menu which will allow you to examine any
available help topic from a help menu.
Portfolio Manager was written using the program commands from
the Foxpro(tm) database package. The data files are in a
standard DBF format. The distribution files were compiled
with the run-time package supplied with Foxpro(tm).
PAGE 2
1.B W H A T I S S H A R E W A R E ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Shareware is a means of marketing Software at a reasonable
price. Developers of software use Shareware to distribute
their products because it provides a minimal distribution and
advertising costs. Advertising costs money. In order to
market a program on a retail basis, a developer typically
needs to sell a minimum of 5000 copies a month. Shareware
circumvents this somewhat and helps provide you, the customer,
with a good value at a much lower price than you would receive
from a commercial source.
In order for shareware to work, IF users are actually using a
product, they must register. Developers can't continue to
develop and improve products if customers don't register and
upgrade. Running a small business costs money. If you enjoy
using a shareware product, either register it or tell the
developer what they can do to provide a product that you will
register. If you don't register, remove the product from your
system and don't use it. Shareware is not Free or Public
Domain Software. You can't expect timely upgrades and fixes
from Free or Public Domain Software. With a Product like
Portfolio Manager, if you register, and you find there are
problems, I will do everything I can to see that the product
works well for you. I will provide you as much assistance as I
can. This unfortunately costs money. I can't do it without
your registration.
PAGE 3
1.C P R O G R A M D E S C R I P T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Portfolio Manager is a record keeping system for investors.
You may split your portfolio into as many as five accounts
to separate your records into categories such as an IRA, an
IRA for a spouse or child, a special purpose account, etc.
PM measures portfolio performance to meet your long range
goals. It computes ROI, estimated & actual yields, as well as
other analytical data. It serves as an excellent tax planning
and preparation tool.
The main features include the ability to maintain the purchase
and sale records; enter dividend, interest, and capital gain
distributions; calculate gain/loss and total return on
investments (ROI); automatically reinvest income distributions;
perform stock splits; and periodically update security prices.
It will allow the selective sales of multiple entries of a
security using a variety of methods - first-in/ first-out (FIFO),
last-in/ first-out (LIFO), or specific shares.
The purchase, sale, or distribution information can be viewed
on the screen, printed or sent to a disk file. The reports
can be selected for one or more securities and one or more
accounts. Reports sent to a file may be combined to build a
custom report combination. There are 17 distinct reports and
an unlimited number of report combinations.
In addition, recently added options allow you to generate
Schedule B and Schedule D 1040 support statements. You may
customize the screen colors and 13 other user defined options.
You may create a full disclosure report on investments, and
select individual accounts for the reports. See PM-FEATU.DOC
for full list of the new & improved features in Ver 4.3
Since PM calculates ROI and yields, income oriented investors
can determine performance including dividends. Most other
portfolio programs simply record distributions, but PM also
factors distributions into calculated performance results.
PAGE 4
1.C.a UNIQUE FEATURES
~~~~~~~~~~~~~~~~~~~~~~
Portfolio Manager automatically updates your investment if
income is reinvested rather then require a separate entry.
You may subdivide your portfolio in up to five separate
accounts. Produces a check list for your 1099's. Creates
supplemental tax statements that may be included with your
1040 tax return. PM generates reports that provide the
information needed to prepare your tax returns. Reports may be
sent to a disk file for later screening or printing.
Maintains broker account records. The program is menu driven
with error checking, on line help, backup routines, and
multiple report options. Files may be automatically tested on
program start. And, best of all, it's easy to use. A bonus
calculator program can import results to a numeric input
request. Two manuals (full & notes) are in a compressed file
on disk #3.
1.C.b GENERAL INFORMATION
~~~~~~~~~~~~~~~~~~~~~~~~~~
Portfolio Manager requires an IBM or compatible. Due to the
size of the program, a hard disk is required. It may be used
used with any monitor and any printer. For best results, you
should have a minimum of 440 KB of free memory - 520 KB is
recommended. PM requires 1.7 MBytes of disk space.
PAGE 5
1.D R E G I S T R A T I O N
~~~~~~~~~~~~~~~~~~~~~~~
This software package is SHAREWARE. This means an author or
programmer has prepared software which you are free to copy,
and share with others, but the author requests a REGISTRATION
FEE for you to continue LEGAL use and to receive additional
benefits. If you received this software from a shareware
vendor or computer club who charged a few dollars, you've only
paid a DISTRIBUTION or HANDLING FEE to produce an EVALUATION
disk of which NO PORTION goes to the author of the software.
You are encouraged to use the software and pay the REGISTRATION
FEE to the author to become legally registered and receive
further benefits specified below. Unregistered users may
examine, search and evaluate the program but may NOT continue
to use it past the evaluation period shown in the license
agreement.
The unregistered version of Portfolio Manager is functionally
identical to the registered version, except the unregistered
shareware version should only be used for a limited evaluation
period. The unregistered version does NOT include the BONUS
(see below) programs, however, the absence of these modules
does NOT limit or restrict the program in the performance of
its primary functions. Installation of the registered version,
when purchased, will not affect the data entered in the
unregistered version. ALL PREVIOUSLY ENTERED DATA STILL
EXISTS AND IS RECOGNIZED BY THE REGISTERED VERSION.
The registration fee for a single copy of Portfolio Manager is
$49.00. (s&h - U.S.A. n/c, $3.00 Canada, $5.00 other).
Payment of the registration fee entitles you to the following:
1) A disk with all the updates since release.
2) Notification of future releases of Portfolio Manager.
3) Unlimited technical support via E-mail, phone or US mail.
4) A module to save and retrieve data from past years.
5) Bonus programs as shown below:
A) CALCULATOR - results may be transferred to the program if
numeric input was requested when the F2 key was activated
B) CALENDAR - check dates forward or backward
C) FINANCIAL CALCULATIONS - 14 ways to evaluate an investment
D) LOAN COMPUTATIONS - seven ways to evaluate a loan
7) An upgrade utility, if needed, to preserve your data from
prior versions
8) My thanks & gratitude (now there is a real incentive !!!)
PLEASE use the registration form included at the end of this
manual OR the form in the file PM-INVOI included with the PM
package. The form may be printed using the program PM-PRINT.COM
or with the command COPY PM-INVOI PRN at the DOS prompt.
To order, you may use your credit card and our TOLL FREE NUMBER
Orders (only) line 800-742-6303 (1-800 SHANE 03)
If you've encountered a problem OR you feel PM lacks certain
features you would like to have, PLEASE, invest .29¢ (a stamp)
and a few minutes of your time to drop me a note. THANKS
PAGE 6
1.E A S H O R T C O U R S E I N D O S
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In this program, as in most software on the market (shareware
or commercial), a knowledge of some basic DOS commands is
usefull, but NOT required. The following is not meant to
teach a course in DOS, but rather to give a user new to
computers some idea on how to do some basic housekeeping.
Some definitions:
Dr: = disk drive (a location in the computer where information
is stored) ( A:>, B:>, C:>, etc.)
filename (F/N) = name used for examples where you subsitute
the actual name for the example name.
Root directory = the main or top-most directory of a hard
disk drive. Usually shown with backslash (C:\>)
Sub-directory (Subdir) = a division of a drive created to hold
a specific group of programs.
File = a grouping accessed by the computer as a complete unit.
Each file has its own directory entry. Throughout the
documentation for PM, files are often referred to as
data files (hold the data you entered) or program files
(contain the commands needed to make the program work).
File Extension = the letter (or numbers) following the period
in a filename.
ie. MANUAL.DOC - "DOC" is the file extension
Some commands:
Create Sub-directory: MD anyname
ex. C:\>MD PM <enter/return>
Make drive active Dr: <enter/return>
ex. A: <enter/return>
Make Subdir active: CD dirname
ex. CD PM <enter/return>
Move file(s): COPY Dr:sourceF/N Dr:destF/N
ex. COPY A:PM-READ.ME C:\PM\PM-READ.ME
PAGE 7
1.F P R O G R A M I N S T A L L A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Portfolio Manager is being distributed in three self-
extracting, compressed files on 3 distribution disks. The
compressed files were produced by the compression program LHA
written by Haruyasu Yoshizaki. Unpacking to a hard drive is
required due to the size of the program. Also on disk # 3 is
the file MANUALS.EXE which contains this manual and the
abbreviated manual, PM-NOTES.DOC in a compressed format.
The installation procedure is primarily for the first time
installation of PM, however, the install program, PM-INSTL.EXE,
is capable of upgrading from an earlier version of PM. The
third question in the install program will ask if the
installation is an UPGRADE from an earlier version.
If you already have an earlier version of Portfolio Manager
installed, install the new version in the same directory as
the earlier version. The new version will NOT overwrite YOUR
data files. The install program will ask if you're upgrading
from an earlier version. If you respond (Y)es it will ask the
location of the earlier version, confirm it, then install the
required files. An upgrade utility will be invoked
automatically when PM is started for the first time.
IF YOU ARE UPGRADING, YOU MUST INSTALL THE NEW VERSION IN THE
DIRECTORY CONTAINING THE OLD PROGRAM AND DATA FILES. YOUR DATA
FILES FROM AN EARLIER VERSION OF PM ARE VALID IN VERSION 4.3.
1.F.a CAUTION:
~~~~~~~~~~~~~~~
The files PORTMGR1.EXE, PORTMGR2.EXE, PORTMGR3.EXE, on the
distribution disks 1, 2, and 3 respectively are self-extracting
compressed files. MANUALS.EXE on disk # # is also a compressed
file containing this main manual and the abbreviated manual
PM-NOTES.DOC
If you start any of them on a floppy disk (ie. enter the name
at the DOS prompt) they will begin the extraction process and
fill the disk in short order producing a "disk write error".
1.F.b PREPARATION:
~~~~~~~~~~~~~~~~~~
You may install PM from ANY floppy disk drive. The program
will ask the location of the distribution diskette and then
confirm it.
As the install program executes you'll be asked to enter the
drive and directory where you want to install PM. The
install program WILL create the directory you name on the
drive you designate.
PAGE 8
1.F.b PREPARATION: - (continued)
~~~~~~~~~~~~~~~~~~
** I STRONGLY RECOMMEND YOU INSTALL PM IN ITS OWN DIRECTORY **
If the directory you name already exists, you'll be asked if
you want to use the existing directory or create a new one.
You'll also have the option to terminate the install program.
PM requires approximately 1.7 MB of disk space. When the
program is started, it requires about 500KB of disk space for
temporary work files. When you exit PM these work files are
erased, however, if the space to create them when the program
starts is not available, the results are unpredictable. I
suggest you have at least 2.2 MB of free space on the drive
where you install the program.
1.F.c TO START THE INSTALL PROGRAM:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
At the DOS prompt enter the command: "PM-INSTL" (no quotes)
For example, if A: is the active drive:
A:>PM-INSTL <enter/return>
****** IMPORTANT NOTE ******
The normal distribution media for the program is on three
360KB, 5.25" floppy disks. You may have received the program
on a different media depending on the source of your copy.
You should be able to install the program from ANY media.
IF YOU'RE INSTALLING THE PROGRAM FROM A HIGH CAPACITY DISKETTE
(ALL DISTRIBUTION FILES ON THE SAME DISK), IGNORE THE CHANGE
DISTRIBUTION DISK COMMANDS THAT APPEAR AS THE INSTALLATION
PROGRAM EXECUTES. JUST PRESS ENTER WHEN ASKED TO CHANGE DISKS.
1.F.d WHAT WILL HAPPEN:
~~~~~~~~~~~~~~~~~~~~~~~~
The install program will lead you through the installation
process by asking your preference on each item.
For most questions a default response is shown in square
brackets (ie. Y/N [Y], yes is the default ). To accept the
default answer, press ENTER (return).
You may use the ESC key anytime the program pauses for a
response to terminate the installation procedure.
PAGE 9
1.F.e DO IT YOURSELF ???? (ie. don't use pm-instl.exe)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
IF you're FAMILIAR with DOS and prefer to do it yourself - THEN:"
1 - Create, then change to, the directory where PM will reside
2 - Copy all files to your HARD disk from the 3 distribution disks
3 - Run each of the 3 PORTMGRx.EXE files (x = 1, 2, & 3). Each
program, as it runs, will self-extract the compressed files.
4 - Run the file MANUALS.EXE to extract the manuals.
5 - Be SURE you have 'FILES=40' & 'BUFFERS=20' in your CONFIG.SYS
6 - I suggest you erase the three PORTMGRx.EXE and MANUAL.EXE
files to save disk space after the installation is complete.
These instructions are purposely vague. If you need examples
or more instructions, you probably should let the install
program do the installation.
FOR USERS UPGRADING FROM AN EARLIER VERSION OF PORTFOLIO MANAGER
** NOTE ** THE FOLLOWING APPLIES TO UPGRADING ONLY: ** NOTE **
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Once you've upgraded to version 4.3, you can NOT use YOUR data
files in a version prior to 4.0. When PM is started for the
first time a conversion program will be activated automatically.
IF you're a REGISTERED USER, it will convert YOUR data files
for use in Version 4.3.
NOTE: After conversion, you can NOT use the converted data
files in a version prior to 4.0. The ONLY way to revert to a
previous version will be through the use of your back up disks.
The install program has the capability to upgrade from an
earlier version of Portfolio Manager, however, if you are NOT
a registered user, the file conversion module will NOT convert
YOUR data files for use with version 4.3. When the conversion
menu has been activated (happens automatically when PM is
started for the first time) you may elect to create EMPTY data
files to EVALUATE the new version.
My reasoning is this: if you've used the program long enough
to accumulate sufficient data to warrant transferring, you
"SHOULD BE REGISTERED".
1.F.f IMPORTANT: (CONFIG.SYS FILE)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Examine the main (root) directory of the drive that is used to
start your computer (usually C: drive). Most computers have a
file there named "CONFIG.SYS". This file is used by the
computer during the start sequence to activate or set certain
features in your computer. For additional information, I
suggest you consult your DOS manual.
PAGE 10
1.F.f IMPORTANT: (CONFIG.SYS FILE) - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Portfolio Manager requires that the CONFIG.SYS file is present
AND that it contains, as a minimum, the following statements:
FILES = 40 (or more !!)
BUFFERS = 20 (or more !!)
Without these lines you'll get a FILE ERROR when you run the
program. It may, of course, have other commands in addition
to the above.
If you already HAVE a CONFIG.SYS file, but it does not have the
above lines or the assigned values are too small, you may use
ANY text editor to add the required lines or change the existing
values. The required lines may be located anywhere in the file
but are generally placed at the end of the file.
NOTE: BE SURE YOU ARE USING THE TEXT (ASCII) MODE OF YOUR WORD
PROCESSOR TO CHANGE OR ADD THE LINES TO YOUR CONFIG.SYS FILE.
If you do NOT HAVE a CONFIG.SYS file you'll need to create
one. You may use your text editor to create the file and
enter the two lines above OR, if you prefer, you may use the
following commands at the DOS prompt:
1 - C:\ <enter> (to get to C: root directory)
2 - COPY CON:CONFIG.SYS <enter> (create the file)
3 - FILES = 40 <enter> (enter the data)
4 - BUFFERS = 20 <enter> (enter the data)
5 - ^Z (Ctrl + Z) <enter> (close file and write to disk)
(hold down Ctrl key and press Z)
NOTE: IF YOU CHANGE YOUR CONFIG.SYS FILE YOU MUST RE-START YOUR
COMPUTER TO ACTIVATE THE CHANGES. The changes you made
will NOT take effect until the computer is restarted.
1.F.g IN CASE OF TROUBLE:
~~~~~~~~~~~~~~~~~~~~~~~~~~
If the installation procedure is interrupted, you may restart
it, however, the following may occur depending on when and
where the procedure was interrupted. If some files were
extracted from one or more of the compressed files before the
interruption, you'll see the following question for EVERY file
that has already been extracted:
xxxxxxxx.xxx Overwrite [Y/N] (where xxxxxxxx.xxx is name
of the existing file.)
Enter an "N" (no quotes) to the question each time it appears.
You may abort the install with a ^C (Ctrl + C) if desired.
If you feel uncomfortable with the above, I suggest you erase
ALL the files in the directory where you attempted to install
PM and then restart PM-INSTL.
PAGE 11
1.G S T A R T I N G P O R T F O L I O M A N A G E R:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
╔════════ STARTING PORTFOLIO MANAGER ════════╗
║ ║
║ TO START PORTFOLIO MANAGER, ENTER THE ║
║ COMMAND "PM" (no quotes) AT DOS PROMPT ║
║ ║
╚════════════════════════════════════════════╝
When the installation process has been completed, the active
directory will be the directory to which you installed
Portfolio Manager.
NOTE: You MUST make the drive and sub-directory containing
Portfolio Manager the active drive and directory BEFORE
entering the command "PM". If this is not the case change to
the appropriate drive/directory. (See 1.E)
To start the program enter the command:
"PM" (no quotes) at the DOS prompt.
ex. C:\PM>PM (assumes you installed PM on C: drive in a
directory named PM)
1.G.a THE FIRST TIME YOU USE IT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The first time the program is started a CONFIGURATION UTILITY
should be automatically activated. It will allow you to
select your preference on certain items that will customize
Portfolio Manager for your personal use. The configuration
utility should be activated EVEN if you are upgrading from an
earlier version as there are many new features that should be
initialized.
If you start PM for the first time (as a new user OR upgrading
from an earlier version), and you see an introduction screen
with the following:
CREATE BACK-UP OF DATA RECORDS Yes No
You should respond with a "Y" or press ENTER and the MAIN MENU
will appear. Next select "MISC" from the Main Menu then OPTION
9 (Configure...) from the MISC menu.
This will activate the Configuration menu. Once in the
Configuration menu, select Option # 2 (color selection) and
select the option appropriate to your monitor (color, black &
white, or monochrome). The use of option # 2 will reset
certain screen features for the current version.
PAGE 12
1.H GETTING STARTED WITH YOUR RECORDS (NEW USERS ONLY)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The most difficult part, in my opinion, of starting ANY new
software package is bringing it up to date with YOUR data.
It may help you determine the best way to enter your data if I
explain how data is handled in the files and at the end of
each year when the "Clear files for a new year" option is used.
As you enter data during the course of the year, it is stored
in the appropriate data file (See 3.E <glossary>). At the end
of each year (when "Clear file for new year" is selected from
the MISC menu) the following happens:
1 - All sales records are deleted.
2 - All income is transferred to a past income file and the
current income records are cleared.
3 - All broker records are totaled and the net balance is
entered as the "beginning balance" for each account for
the new year. The broker files are then cleared.
The income from past years will be retained in the past income
file and provide more accurate information for ROI computation
and yield but are NOT REQUIRED FOR ANYTHING ELSE.
As you may have gathered from the above, Portfolio Manager
does not normally maintain history files except for income.
Even the income history file is used ONLY to compute ROI and
yields. Considering the above, there isn't much benefit to
trying to enter ALL your past transactions.
Before you start, I strongly recommend you review the sections
on entering data especially parts 2.3 (purchase), 2.5 (income),
2.6 (broker), and 2.7 (sales). I suggest you pay particular
attention to constant value entries such as CD's, savings, etc.
in section 2.3.A.
Below are three different ways to start your data into the
program. I suggest using # 2 below.
1.H.a 1 - QUICK START OF YOUR DATA:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As a very minimum, you may enter the total shares (including
re-invested shares) currently held for each investment you own
using the purchase option. Use the income option to post the
total income received for each of those investments. If the
income for a security was reinvested, you should still include
the dollar amount in the total income entered. As you enter
income you'll be asked if you want to re-invest the income.
Answer NO while you're starting your data with this method.
Enter all sales using the sales option.
If you enter your data as suggested above, the ROI and yield
will be inaccurate. A total or partial sale of the investment
will not separate your long/short term gains/loss. The income
reports will not reflect your correct past income figures.
PAGE 13
1.H.b 2 - STARTING YOUR DATA RECORDS: (suggested method)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To enter YOUR data, I suggest you do the following:
1 - Select "Broker" from main menu. Make an entry for each of
your accounts to reflects the balance on the FIRST of the
CURRENT (this) year.
2 - Select "Purchase" from MAIN MENU and then "Enter a new
investment", opt 1, from the submenu. Enter the total
number of shares of EACH security currently owned on the
FIRST day of the CURRENT year. Use a weighted average for
the cost and the original purchase date for the record.
3 - While still in "Purchase..." menu, use "Add shares...",
Opt #2, to reflect any shares that were added THIS year
through an additional purchase and NOT reinvested from
dividends.
ie. Do NOT enter shares acquired during the current year
due to the re-investment of dividends or capital gains
at this time - they will be entered in the next step.
4 - Select "Income" from main menu. Enter ALL income received
during the CURRENT year including dividends that were
reinvested. The reinvested shares will be automatically
posted to your total holdings IF they were reinvested.
NOTE - Do NOT enter income, etc. for any prior years in the
current year as it will distort the accuracy of the
associated reports.
5 - Select "Sales" from main menu. Enter EACH sale for the
CURRENT year.
NOTE - For steps 3,4,& 5, debit or credit broker account as
appropriate.
1.H.c 3 - AMBITIOUS START OF THE DATA ENTRY:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The entry methods suggested above will ONLY effect the accuracy
of the analytical and evaluation data. This data (ROI, yield,
etc.) is NOT part of the permanent records. It is computed
each time a report is requested.
If you're ambitious, you may consider entering all transactions
from past years. If you choose to do this, consider the
following.
PAGE 14
1.H.c AMBITIOUS START DATA ENTRY: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you choose to enter data into past years, you should keep
in mind that ALL entries for the year in question MUST be
completed BEFORE proceeding to a subsequent year. This means
that ALL the securities with transactions during the year in
question MUST be entered before proceeding. When ALL entries
for the year have been completed, use the procedure "Clear
files for a new year", (MISC menu, option 6) to update the
various records. Next start the procedure for the next year
and continue this way until you've completed each year up to
the current one.
- in other words, if you're posting data for 1989, complete
ALL entries needed for 1989 before entering data for 1990 etc.
then use "Clear files for new year" before beginning 1990.
EXAMPLE OF EACH START METHOD DISCUSSED ABOVE:
The investment:
You bought 1000 shares of XYZ fund 5 years ago (1/1/88) at
$10/sh with income paid and re-invested quarterly. It is now
7/15/93 and you've received two quarterly $250 re-invested
dividends thus far this year. You own 1600 shares on this
date (7/15/93). I assumed a 10% yield and didn't calculate
exact yields and share numbers for the example.
1 - QUICK START YOUR DATA:
With PURCHASE option #1, enter 1600 shares of XYZ @ $10 (avg
cost) with a purchase date of 1/1/88. Next use INCOME to
enter $500 in dividends received YTD but do NOT enter as re-
invested. Your next quarterly dividend will be entered thru
INCOME and re-invested as normal.
2 - STARTING YOUR DATA RECORDS: (suggested method)
With PURCHASE option #1, enter 1550 shares of XYZ @ $10 (avg
cost) with a purchase date of 1/1/88. Next use INCOME to
enter the $250, 1st qtr dividend and show it as re-invested
(25 shrs). Use INCOME to repeat for the 2nd qtr div. You now
have the 1600 shrs and your yield is accurate for the current
year (ROI will not be accurate).
3 - AMBITIOUS START DATA ENTRY:
With PURCHASE option #1, enter 1000 shares of XYZ @ $10
purchased on 1/1/88. Use INCOME to enter each $250 quarterly
dividend for 1988 and show it as re-invested (25 shrs ea
time). When you've entered all of 1988, generate any desired
reports and then use the "Clear files for new year" option in
the MISC menu BEFORE entering any data for 1989. Repeat the
income posting for each year until current.
SPECIAL NOTE: As part of the "Clear files for a new year"
option, REGISTERED users will be asked if they want to
preserve the current years data in recallable history
files. See Ch 2, sect 2.8.E and Ch 2, sect 2.8.F.
PAGE 15
HINT: If you expect to make MANY entries for a year other
than the current year, such as when loading your initial
data into the data files, you may consider changing the
computer's active year to avoid the confirmation process
in PM for every entry you make. Proceed as follows for
each year you plan to enter.
1) Exit PM
2) At the DOS prompt enter a date in the desired year in the
format mm-dd-yy ie. C:\>date 01-01-88
3) Restart PM
4) You must change the program's reference year with the "Clear
for a new year" routine OR the configuration routine (select
Configure from the MISC menu, change something and then
exit back to the MISC menu).
NOTE: DO NOT FORGET TO RESET THE COMPUTER'S YEAR TO THE
CALENDAR YEAR WHEN YOU'RE FINISHED.
NOTES TO GETTING STARTED:
1 - If you're a registered user and you elect to post records
for prior years, you may preserve the data as part of the
"Clear for New Year" procedure. This will allow you to
recover past year data if needed. You will be asked if
you want to use this feature when you select "Clear...".
2 - Yields will be inaccurate if income is posted in a lump
sum. ie. If a $10.00 stock pays .25 per qtr and is posted
as a $1.00 entry for the year, it will show as a 40% yield
(4 x $1) because the program expects four payments per yr.
****** W A R N I N G ******
Portfolio Manager does NOT separate data by the year for
reports, analytical data, etc. Because of this you should NOT
enter data (primarily income and sales data) for different
years until you have generated ALL the reports for that year
AND run the "Clear for a new year" routine in the MISC menu.
In other words: If you want to enter all your data for 1992
do NOT enter 1993 data UNTIL you have generated the desired
reports for 1992 AND then ran the "Clear files for New Year"
option. The above discussion doesn't apply to purchases.
Purchases may be entered any time.
SPECIAL NOTE: As part of the "Clear files for a new year"
option, REGISTERED users will be asked if they want to
preserve the current years data in recallable history
files. See Ch 2, sect 2.8.E and Ch 2, sect 2.8.F.
PAGE 16
1.I CREATING AND USING SAMPLE DATA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you would like to experiment with entries prior to entering
YOUR data, do the following:
1. Start the program (enter PM at DOS prompt)
2. Configure the program (automatic first time the program
is started otherwise select MISC opt # 9)
3. When you exit Config, the program will restart with the
new settings. The opening screen asks you to "Make
backup...". Answer (Y)es !!
4. Enter your practice data (or real data if you like).
5. On subsequent starts, do NOT answer (Y)es to backup
question on the opening screen UNTIL you have decided
to KEEP the entered data.
6. When you want to remove all the practice data, select
option # 9 from the MISC menu (Configure...) and then
option "F" from the submenu (Clear all data files).
This action will reset the files to the way they were on
the distribution disk (ie. you'll have to re-enter your
name, your account names, etc.). You will then be ready
to enter YOUR real data.
1.J H E L P S C R E E N S
~~~~~~~~~~~~~~~~~~~~~~~
The help program was designed to be activated AFTER you've
selected a desired feature from the menu. After you've
activated the selected feature, use the F1 key for help.
You'll be given suggestions and hints on how to use the
selected function.
There are several features which may not be intuitive or are
used so seldom (EOY posting, Mergers, etc.) that additional
help would be advisable. For these topics I've placed a
reminder on the screen to "see F1 (Help) before using". If you
prefer that the reminder windows do NOT appear on the screen,
there is an option in the configuration menu (option E) to
block most of them from appearing. The help will still be
available by using the F1 key.
You may select "Topics" from any help screen by using your
mouse or by entering "T" on the keyboard. This will activate
the HELP MENU with a list of topics that have help available.
Use arrow keys OR point and click with a mouse to select the
desired topic, then press enter.
PAGE 17
1.J H E L P S C R E E N S - (continued)
If you have a mouse, you may move or re-size the help window.
Point to the lower right corner and hold down the left mouse
button. Drag the window to the size you desire. To move the
window, place the mouse on the top of the window, hold the
left mouse button down and drag the window to the desired
location. If you click the mouse on the top right corner, the
window will expand to the full screen size. The next time you
access help, it will appear in the size and location where you
placed it the last time you exited help.
Help may be exited with the escape (ESC) key or point your
mouse to the top left corner. You'll be returned to what you
were doing when you activated help.
Most help "topics" apply to their corresponding listing in the
program menus. Several subjects are used in many functions
but are NOT called by the F1 key. (ie. numeric input, yes/no
response, etc.). I suggest you review them once or twice with
the "Topics menu" to become familiar with their use.
In some features the F1 key will activate the "TOPICS" menu
automatically. This will occur on subjects that I felt were
self explanatory and, honestly, I couldn't think of anything
more to say about the current subject.
PAGE 18
C H A P T E R 2
~~~~~~~~~~~~~~~~~
U S I N G T H E P R O G R A M
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2.0 G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The following subjects cover program features and functions
that are not specific to any individual routine within the
program.
2.0.A THE MAIN MENU:
~~~~~~~~~~~~~~~~~~~~~
The Main Menu items should be self descriptive of their
function. Select your choice by moving the bar to your option
with the arrow keys OR enter the first letter of your choice.
You may use your mouse to point & click on your choice.
The bar will move across the top row of the screen and a
summary of the available options for that selection will be
shown on row 2 of the screen. When you've entered a choice, a
window will appear with the available options in the selected
function.
Feel free to examine the options as they ALL allow you to EXIT
(return to main menu) without changing the data.
2.0.B THE SUB-MENUS:
~~~~~~~~~~~~~~~~~~~~~
SUB-MENU options, like the main menu options, should be self
descriptive. As you move thru the options a brief description
of the feature will appear on line 23 of the screen.
All the options have a provision to exit without affecting
the data files. In most options, when the program pauses for
input from users, a CONTEXT SENSITIVE HELP SCREEN is available
by pressing the "F1" key which expands on the information
requested at that point.
AFTER you select the desired option, the F1 key will activate
help with information on the selected option.
The "ESC" key is available to exit (cancel) ANY routine WITH-
OUT a change to data."
PAGE 19
2.0.C SELECTING ACCOUNTS:
~~~~~~~~~~~~~~~~~~~~~~~~~~
Many functions allow you to specify a specific account for
the current function. This is especially true in the report
options where you are always asked to specify the desired
account (or all accounts).
If the selected routine allows the selection of a specific
account, a pop-up menu will appear on the screen listing the
available accounts. These are, of course, the accounts you
created when you configured the program.
To select a specific account, move the bar to the desired
account using the arrow keys or the PgUp/PgDn key and then
press enter. You may also point and click with a mouse or
enter the number of the desired account.
Each pop-up menu will also allow you the option to chose all
the accounts or return to the calling menu. You may exit the
menu using the escape (ESC) key.
2.0.D CREATING HOLD (.HLD) FILES:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Files ending with the extension ".HLD" are data backup files
created by the program when requested by you. These ".HLD"
files will be in the same directory where you've installed PM.
ex. PMPURCH.HLD is the backup file for PMPURCH.DBF
There are 3 ways to create these ".HLD" files. All three
methods will create the same files in the same way and put
them in the same place.
1. Respond "Y" to the backup question on the opening screen.
2. Use the F3 key while working within the program.
3. Select option 5 in the EXIT menu.
Any of the above will create six data files with an extension
of ".HLD" in the same directory from which you're running PM.
NOTE: Five of these files are the data files and the sixth
is the file containing the user assigned variables.
Every time you start the program or a program re-start is
called by a function, you will be asked if you want to create
the ".HLD" files. Usually answer "Y" (or press return ) unless
you have a specific reason to not create the files.
SUGGESTION: If you have reason to think there may be a
problem with the data, do NOT respond Y(es) to
the "backup" question as you may be overwriting
the valid data in the ".HLD" files with the bad
data from the active files.
PAGE 20
2.0.D CREATING HOLD (.HLD) FILES: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From within the program, you may use the F3 key any time a
main or sub-menu is active on the screen. The F3 key is
blocked from use when data files are in use. The program will
inform you if it can't create backups when requested.
You may find this feature useful if you're uncertain on the
effect of a specific entry.
For instance:
I sometimes experiment with the sale of different combinations
of securities to see the effect they will have on taxes, etc.
Before starting to "fool" around, I make a current ".HLD" file
with the F3 key then when I'm finished I use the recovery option
to replace the altered data with the accurate (current) data.
The exit menu has an option to create backup files (option #5).
This function is identical to the other methods of ".HLD" file
creation.
Regardless of how you request the backup files, a backup of
all your data up to that point will be created in the same
directory as PM. The backup files will have the same file-
name as the corresponding ".DBF" file but will have a ".HLD"
extension instead of ".DBF". (ie. PMPURCH.HLD)
Now, if there's a power failure, or the program fails, you
will ONLY loose data that has been entered since last time you
created the ".HLD" files.
NOTE: You should answer "N" to the "backup" question if you
suspect the current data may be corrupt and you want to
examine the data to see if the problem can be found and
resolved.
NOTE: I'm a firm believer in backups. I've lost data in the
past. I've tried to make it as easy as possible for
you to keep a backup current. The ".HLD" files will
help if there is a data problem. They will NOT help if
there is a mechanical problem with your hard disk.
NOTE I make it a personal practice to create ".HLD" files
from the EXIT menu (opt # 5) when I have completed a
session IF (and only if) I feel comfortable with the
data I just entered.
DO NOT NEGLECT MAKING REGULAR BACKUPS TO ANOTHER (FLOPPY) DISK
FOR ADDED PROTECTION.
To create a backup to another disk drive use MISC option # 4.
PAGE 21
2.0.E ENTERING DATES:
~~~~~~~~~~~~~~~~~~~~~~
If a date is requested by the program, you may use the return
key to accept the current date. In most places where a date
is requested, the current date will be shown as the default.
ie. Enter date (ret = 07/15/93) ________
To enter a different date, it's NOT necessary to type the year
IF you want to accept the active record year.
ie. for 07/15/93, enter 07 15 then press return. The year
will default to 93 (assuming the record year is 93).
In some date requests, the program expects you to enter the
CURRENT record year. If you enter a different year, a window
will appear and ask you to confirm the entry. You may confirm
your entry or have the opportunity to re-enter the date.
This feature applies to all the data that you would expect to
apply to the active year such as income, and sales. You may,
of course, enter a different year but expect to be challenged.
NOTE: PM maintains a reference year in the PMMEMORY.MEM file.
This allows you to post entries in January of a subsequent
year without being challenged if the correct year was
entered. The internal reference year is reset to the
calendar (computer) year when you run the "Clear files
for a New Year" option in the MISC menu.
2.0.F EDITING ENTERED DATA
~~~~~~~~~~~~~~~~~~~~~~~~~~~
At the end of every data input module you'll be asked to
verify and accept the data just entered.
If you made a mistake in responding to the requests for
information you should respond "NO" to the "ENTRIES OK"
question. You'll be asked if you want to edit the entry.
A "NO" response to the "edit" question will exit the routine
without making ANY changes to the records.
To make a simple change of one or more items use the arrow
keys to move the cursor to the desired item then press enter.
After you've made the change, press enter and you will be
asked again if you want to approve the entry.
The cycle will repeat until you accept the entry OR you exit
by pressing ESC or responding "NO" to the edit entry option.
HINT: Often it is easier to use the ESC key to cancel an
entry and then re-enter the entry from the beginning.
PAGE 22
2.0.G ENTERING NUMERIC DATA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Numeric input is straight forward, however, there are several
things you may want to consider.
Some numeric requests will NOT accept a zero (0) as the input.
This would apply to a field where a zero (0) would produce a
meaningless record.
ie. amount of dividend you just received.
If you are a "REGISTERED" user, you may use the calculator (F2)
to compute the numeric input. The calculator results will be
transferred to the requested input field when you exit the
calculator. You will still have an opportunity to accept or
change the results.
2.0.H SECURITY SELECTION:
~~~~~~~~~~~~~~~~~~~~~~~~~~
Whenever the selection of an individual security is required
such as in the posting of income, a pop-up menu will appear
with a pick list of all the securities.
The securities shown in the pop-up menu may be selected by
moving the bar with the arrow keys or by point and click with
a mouse. You may also use PgUp, PgDn, Home, or End to locate
the security.
You may jump to a security by entering the first letter of the
name. The bar will jump to the first security that starts
with the letter you just entered.
To exit the security selection menu WITHOUT choosing a security,
press the ESC key.
2.0.I TRANSACTION REMARKS:
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Many of the transactions allow for the entry of a remark.
If you respond "Y" (Yes) or click the mouse on Yes, you'll
activate a window for you to enter the remark.
Enter any appropriate remark. All remarks will be displayed
at the end of the appropriate report. In some cases the same
remark may appear in several reports.
When you request a report, you'll be asked if you want to
include your remarks with the selected report.
PAGE 23
2.0.J BROKER ACCOUNT DURING DATA ENTRY:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Almost every transaction that involves money asks if you want
to debit or credit the broker account.
If you respond "Y" (Yes) or click the mouse on Yes, you'll
be asked how much, where appropriate, and the amount you enter
will be posted to the broker records.
The amount will default to the amount of the transaction and
the program will not let you enter an amount that exceeds the
amount of the transaction.
Of course, you may debit or credit the broker account directly
with the broker function (see Chapter 2, section 2.6.A & B)
SUGGESTION: I recommend you use the broker account for every
monetary transaction to provide a paper trail for
your funds.
Why ??? While the income report will show that
you received the income, the broker report will
show where it went (and it does seem to go !!!!)
Example: You receive a dividend check from a stock. Enter
it with the INCOME option and credit the broker
account when asked. Next use the BROKER option
and debit the broker account for the same amount
(with a remark ????).
PAGE 24
2.1 E X I T M E N U
~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The exit menu contains features I felt were not miscellaneous
functions and hence were not put in the MISC menu, but they
also did not fit into other categories so here they are - in
the exit menu.
2.1.A TERMINATE THE PROGRAM: (EXIT option # 1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is, as the name implies, the point where a NORMAL program
termination is executed.
****** W A R N I N G ******
DO NOT TERMINATE THE PROGRAM BY RE-BOOTING THE COMPUTER OR
TURNING OFF THE POWER SWITCH. IF YOU TERMINATED THIS WAY, SEE
BELOW FOR MORE INFORMATION ON REMOVING FOXPRO(tm) WORK FILES.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
When you complete your session with PM, you MUST exit the
program via the "EXIT" option from the Main Menu and "TERMINATE
PROGRAM" option from the EXIT Menu.
There are two reasons:
1) During a normal program exit, PM will update your data
files and any memory variables that were changed. If you
terminate the program by turning the power off OR re-
booting the computer, the regular data files will NOT be
updated and closed properly. This COULD result in a loss
of data. While the program is running, PM creates
temporary work files. These files ALWAYS have a filename
starting with "TEMP" (no quotes) as the first four letters.
These files will be erased during a normal shutdown.
ex. TEMPDNUM.DBF
I created PM by using the programing commands provided with
the Foxpro(tm) data base package. When you start Portfolio
Manager with the PM command, you are actually starting the
Foxpro(tm) runtime engine which in turn calls the main program.
2) When Foxpro(tm) starts it creates it's own work files
on your hard disk. These files are named by Foxpro with
random letters and numbers. They can be any combination
but the work file name will NOT have an extension. For
instance you may see a file in your PM directory like;
AADXRETG. or E4VF5TTE. etc.
The key to identify these files is there is NO extension
(ie. the 3 letters following the period in a file name.)
If you exit PM by re-booting or just turning off your
computer while PM is still running, you WILL leave these
Foxpro work files on your disk. They can be from 0K to
over 400K in size.
PAGE 25
2.1.A TERMINATE THE PROGRAM: - (continue)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
When you exit PM with the EXIT option # 1, these Foxpro
work files are removed from your directory.
NOTE: If you find the Foxpro(tm) work files in your PM
directory when PM is NOT active, you should erase them
with the DOS ERASE command. You can ALWAYS recognize
them by the lack of an extension in the filename (they
are the ONLY files in the PM directory without an
extension). They will NOT be erased by the program the
next time you use PM even if you exit normally.
NOTE: Any time the program has an abnormal shut-down, the
next re-start will activate a special screen suggesting
the file testing functions be run. I recommend you run
the tests as suggested.
NOTE: If the program is terminated because of a program error
(bug), the Foxpro(tm) work files WILL be cleared and
the data files closed. The files starting with "TEMP"
created by PM will remain on the disk but will be
erased the next time you exit the program normally.
2.1.B REVIEW INVESTMENT STATISTICS: (EXIT option # 2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The statistic review will display an overview of the entire
portfolio. It has no setup options, but is intended to
present the major numbers in a quick summary format.
It was not designed to be printed. It's only there to massage
your ego by showing the tremendous gains you've received from
your judicious selection of investments and excellent timing
in the sale of securities while earning maximum income in the
interim. (now there's a sentence)
2.1.C FOR TECHNICAL ASSISTANCE: (EXIT option # 3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you've encountered a problem with the program or need
technical assistance please contact:
Steve Hane
Shane Software Int'l
107 17th Court
Sequim, WA 98382
Technical Support line (206) 681-2402
Technical assistance is NOT restricted just to registered
users. I feel that if there is a problem, I want to know
about it and make every effort to correct it whether it's a
programing bug or confusion over how to do something. If I
feel you're asking questions that should only be answered for
a registered user, I'll say so.
PAGE 26
2.1.C FOR TECHNICAL ASSISTANCE: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As of the preparation of this manual, Shane Software is not
large enough to support a full time office. If you attempt to
contact me by phone and don't get an answer, PLEASE try again.
I will accept calls at any REASONABLE hour (9am to 9pm Pacific
time) seven days a week. Generally early evening is best.
Perhaps, by the time you read this, (and with your support),
I'll have full time coverage.
NOTE: Please see Chapter 3, section 3.D (In case of trouble)
for additional information in resolving problems.
If, during the execution of the program, a technical problem
(bug) is encountered an error screen will be activated with
the following message:
The file,"xxxxxxxx.ERR", was created containing the
information I NEED to trace the problem. Please send
me a copy of the error file. I need the ACTUAL file,
NOT a copy of this notice with the file name. You may
send the file(s) on disk or as a printout(s). Without
the actual error file, I can ONLY make an educated guess
NOTE: xxxxxxxx.ERR is a randomly assigned filename for
the error file
This error file will be written to the same directory in which
PM is located. Please do NOT send me a copy of the screen or
just the name of the error file (xxxxxxxx.ERR) as it has NO
value to me in resolving the problem. It is the actual file
that is created that has the information that I will need to
attempt to trace the problem.
If you re-tried the SAME routine several times and the same
error re-occurred, a new error file will be created each time
the error occurs. Each of these error files will have a
DIFFERENT name but will contain the SAME information.
If this is the case, you need only send the file with the
latest time and date stamp. If you're uncertain, by all means,
send all the error files. It doesn't matter whether you send
the error file(s) on a disk or as a print out. Do whichever
is easiest for you.
NOTE: To send all the error files on a disk enter the following
command from the DOS prompt in the PM directory:
ex. C:\PM>COPY *.ERR A:
Thank you for your patience !!!!!! (sch)
PAGE 27
2.1.D CANCEL ENTRIES THIS SESSION: (EXIT option # 4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you feel that you need to cancel ALL the entries you've
made this session use option 4 in the EXIT menu.
This is the OOP's, I goofed, option.
Actual use of the option is straight forward. If you feel
confident in your ".HLD" files, just respond "Y" (yes) to the
continue question that appears when the option is selected.
The primary use for the feature is to remove entries posted to
the records incorrectly or in the wrong place. Using this
routine is easier and safer in many cases than trying to edit
the entries.
Example - you enter a re-invested dividend and then realize
you posted it to the wrong fund. You could delete
the entry from the income records (income posted)
and the purchase records (additional shares) - OR -
you could cancel entries completely by recovering
the ".HLD" files.
Before using, consider the following:
The ".HLD" files are created in one of 3 ways.
1. Responding "Y" to the backup question on the opening screen
2. When you use the F3 key during a session
3. Selecting option 5 in the EXIT menu.
Any of the above will create six data files with an extension
of ".HLD" in the same directory from which you're running PM.
See Chapter 2, section 2.0.D (creating HLD files) for additional
information on HLD files.
CAUTION:
The cancel option works by restoring data from the files with
the ".HLD" extension. The restored data will be from the LAST
time you created the ".HLD" files regardless of which method
was used to create them. If you haven't saved the data with
one of the above recently, the recovered data will be from the
last time you DID create the ".HLD" files. Please consider
the timeliness of your ".HLD" files if you decide to cancel
the current entries with the selection of this option.
CAUTION:
If you backed your data during the program start and then
discovered the data is corrupt, the ".HLD" files will contain
the same problem.
NOTE: This function is identical to MISC option 7, sub-option 1
(backup recovery). See Chapter 2, section 2.8.G.a.
PAGE 28
2.1.E CREATE "HLD" FILES AS DURING PM START: (EXIT option # 5)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Option 5 in the EXIT menu is one of the three ways to create
".HLD" files in the same directory where PM has been installed.
Before using this option, be sure the data you've entered is
valid and as you want it to be.
See Ch 2, section 2.0.D (creating HLD files) for additional
information on ".HLD" files.
2.1.F INFO ON PROGRAM REGISTRATION: (EXIT option # 6)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
REGISTRATION - MY PERSONAL FAVORITE
If you select option 6 in the EXIT menu, you'll be presented
with the help screen informing you how and where to register
the program. It will also tell you what to expect in return
for your registration fee.
The registration fee for a single copy of Portfolio Manager is
$49.00. (s&h - U.S.A. n/c, $3.00 Canada, $5.00 other).
Payment of the registration fee entitles you to the following:
1) A disk with all the updates since release
2) Notification of future releases of Portfolio Manager
3) Unlimited technical support via E-mail, phone or US mail
4) A module to save and retrieve data from past years
5) Bonus programs as shown below:
A) CALCULATOR - results may be transferred to the program if
numeric input was requested when the F2 key was activated
B) CALENDAR - check dates forward or backward
C) FINANCIAL CALCULATIONS - 14 ways to evaluate an investment
D) LOAN COMPUTATIONS - seven ways to evaluate a loan
7) An upgrade utility, if needed, to preserve your data from
prior versions
8) My thanks & gratitude (now there is a real incentive !!!)
PLEASE use the registration form included at the end of this
manual OR the form in the file PM-INVOI included with the PM
package. The form may be printed using the program PM-PRINT.COM
or with the command COPY PM-INVOI PRN at the DOS prompt.
To order, you may use your credit card and our TOLL FREE NUMBER
Orders (only) line 800-742-6303 (1-800 SHANE 03)
Additional info on registration is available in Ch 1, Sect D.
PAGE 29
2.1.G MULTIPLE PORTFOLIO MANAGER: (EXIT option # 7)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Portfolio Manager has the ability to manage an unlimited
number of investment portfolios for those having the need
(brokers, advisors, counselors, etc.). This module sold
separately and is available to REGISTERED USERS ONLY for an
additional $50.00. This module is NOT required for the normal
use of the program by individuals. It may be a useful feature
for those who maintain portfolios for others.
If you've purchased the MPM module, option 7 will activate
the program. If you select option 7 and you don't have the
MPM module, you will be given additional info on its purpose
and use.
PAGE 30
2.2 R E P O R T M E N U
~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You have the option to print, screen, or send the report to a
disk file for later printing.
The reports may displayed in an expanded or compressed format
(see below).
The configuration menu (MISC opt #9) has an option to suppress
reports that will have NO entries to display. This feature
was included to preclude the printing of pages with only a
report title and no information. ie. You haven't sold any
stock in the current year; the sold report would NOT be
printed (or screened) if this feature had been selected.
SPECIAL NOTE ON NUMERIC DISPLAYS:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If a line contains one or more asterisk (*) it means the
computed data is unrealistic OR too large for the allotted
space in the report. To create reports, the size (number of
digits) of numerical output must be preset while programing.
If the output exceeds the allotted spaces the digits are shown
as asterisks.
ie. an ROI of 1000.00% will be shown in the report as ***.**%.
Maybe you did receive a 1000% ROI (good for you) but I had to
format the output to 3 digits.
REMARKS:
~~~~~~~
Most reports allow the inclusion of remarks you may have
entered as you made the original entry for the transaction.
In some cases, the same remarks will appear in different
reports. For example the "Value" report will show the same
remarks as the "Purchase" report. Some remarks from the
income report will appear in the "Purchase" report if they
were attached to a re-invested dividend.
ACCOUNT SELECTION:
~~~~~~~~~~~~~~~~~~
You may designate a specific account for the report or select
all the accounts. Where applicable, the reports will display
the data separated by the accounts you established during
configuration (if any). You may elect to show one or all
accounts in the report. See chapter 2 section 0.C (account
selection)
To select a specific account, move the bar to the desired
account and press enter. You may point and click with a mouse
or enter the number of the desired account.
PAGE 31
REPORT FORMATS:
~~~~~~~~~~~~~~~
There are two ways to prepare the contents of a report. For
example, you buy 100 shares of a stock (XYZ corp) and then buy
10 additional shares each month for a year.
1. COMPRESSED: ALL transactions in ONE line for each
security. This report format shows multiple transactions
for an investment in a SINGLE line for the selected report
subject. In most reports, the date shown will be the date
of the last transaction.
ie. In this example, the report will show all 13 entries
for XYZ corp in a single line with 220 shrs, an average
price, and the date of the last transaction.
2. EXPANDED: New line for EACH transaction for a security.
This report format will show every transaction for the
selected report subject.
ie. In the example, the report will show 13 separate lines,
one for each transaction.
NOTE: The expanded report can be quite long if you own a
large portfolio or have held and re-invested funds for
a long time. To examine an expanded report of a
selected individual security use Option 6 of the Misc
report options.
REPORT - DISPLAY OPTIONS:
~~~~~~~~~~~~~~~~~~~~~~~~~
SCREEN:
The report will pause each time the screen is filled. You may
press "ESC" anytime to exit the report prematurely.
The report date and heading are not shown on a report to the
screen as they are in a report to the printer or disk file.
PRINTER:
The program will verify that the printer is on. If it detects
a problem, it will ask you to check if the printer is on line.
Start the paper with the top of the paper aligned with the top
of the back plate. The program does NOT eject the first sheet
as a blank page.
If you elected to print an expanded report be aware that it
may require quite a bit of paper even you don't own many
securities. For example, if you owned a fund for 10 years and
reinvested monthly, the report for that one investment will
require 120 lines (over 2 pages with headings, etc).
PAGE 32
REPORT - DISPLAY OPTIONS: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~
DISK:
You may send the report to a disk file instead of the screen
or the printer.
By sending the report to a disk file, you may build your own
custom report grouping in a single file which you may screen
or print from DOS.
Enter a UNIQUE file name for the report unless you're building
a custom report. An extension of ".TXT" will be added to the
name automatically.
If the report name exists, you will be given three options;
1) Enter a new name
2) Add to file
3) Overwrite the existing report
To build a custom report, select the option to add to an
existing report (option 2). This will combine the previous
report data with the currently selected report option.
The report(s) you sent to a disk file may be screened or
printed at any time from the DOS prompt.
To PRINT: at the DOS prompt, enter the command:
COPY filename.TXT PRN:
To SCREEN:at the DOS prompt, enter the command:
COPY filename.TXT CON:
HINT: At the end of each year, I like to send all the reports
in a COMPRESSED format to the printer and ALSO send all
the reports in the EXPANDED format to a floppy disk to
keep for future reference if needed. I usually name
the disk file by the year. (ie. 1992)
NOTE: A report that has been saved to a disk file may be
printed using the MISC report menu option #7.
See 2.2.l.g (print rept from disk file) below.
REPORT PAGINATION:
~~~~~~~~~~~~~~~~~~
NOTE: If there appears to be a problem with report pagination,
try changing the printer configuration (MISC menu opt 9,
then config menu opt # 9) to indicate you're using a
laser printer even if you're not. It will cause the
page line count to be reduced.
2.2.A GENERATE REPORTS 2 - 9: (REPORT option # 1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This feature was included to allow you to generate all the
primary reports with a single report preparation. As noted
above, if you select the expanded information, the report
could be quite lengthy. Be sure to have enough paper in the
printer if it is to be printed.
PAGE 33
2.2.B INVESTMENT PURCHASE RECORDS: (REPORT option # 2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The report will show the pertinent information for each
purchase. If you selected the compressed report, you'll see
each investment in a single line with the date shown as the
original purchase date even if there was a subsequent
acquisition of additional shares. As with all the reports,
you may limited the report to a selected account.
2.2.C CURRENT VALUE OF PORTFOLIO : (REPORT option # 3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The current value report will show the per share cost and the
per share value. It will also show the total cost and the
total value for the each security or record.
If you selected the compressed report, you'll see the cost and
value of each investment in a single line. The expanded will
show the cost and value of each acquisition for the same
security. As with all the reports, you may limited the report
to a selected account.
The values shown will be from the last time you used the
update function. (Chapter 2, section 2.4)
2.2.D DIVIDEND & INTEREST REPORTS: (REPORT option # 4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The dividend report displays a date, the total income with a
breakdown of the capital gains and tax free income. It also
shows the estimated and year to date yields. If there were
any re-invested shares they are shown also.
If the compressed report is selected, the date will be the
date of the LAST entry and the dollar amounts will be the
total received to date in the current (active) year. Of
course the expanded report will show each income entry.
When you first purchased an investment, you were asked to
enter the number of income payments you expected annually.
This number is used to compute the estimated yields. If you
did not enter an accurate number the yields will, of course,
not be accurate. Another weakness in the estimated yields
occurs if you receive a disproportional payment.
NOTE: The estimated yield is computed by taking the average
of the income received YTD and multiplying it by the
number of times you indicated you expect to receive
income each year. You may change the number (times per
year) with the Edit option (Misc opt #1 (purchase
recd's)). All the yield figures are based on averages.
If the income is uneven, yields will be inaccurate.
PAGE 34
2.2.D DIVIDEND & INTEREST REPORTS: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTE: All yield percentages are calculated as they are needed
and do NOT become part of the permanent records. They
are for analytical use only.
TIP: If you entered the wrong number when asked "Number of
income payments expected per year" during the initial
entry of the investment in the PURCHASE menu, you may
change it with the "EDIT" option in the "MISC" menu.
(See chapter 2, section 2.8.A (edit a file))
2.2.E REPORT ON SOLD INVESTMENTS: (REPORT option # 5)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As with the other reports, you have the option to produce a
compressed or expanded report. The sales report does NOT give
you the option to select the account to be reported.
The sales report will separate short and long term capital
gains according to the capital gains period established during
configuration. IRA sales are reported separately from the
long and short term sales. If an IRA sale is a taxable event
you will still have the information available for reporting.
NOTE: Do not forget to change the "Capital Gain Period" if
congress changes it. It may be changed from within the
CONFIGURATION menu, option B.
TIP: I won't pretend to understand the tax laws regarding IRA
gains and losses, however, I strongly suspect you'll
need this information at some time in the future. I
suggest you keep the printed (or disk) sales report
(as it pertains to IRA's). Remember the program does NOT
preserve a sales history. When you run the "Clear for
new year" function WILL remove the sales data.
Example of a sales report:
Name: PUGET SOUND BANCORP Shares sold = 48.902 Account: JNT
Purchase date: 01/01/88 Date of sale: 06/22/92 Held 4.47 yrs
Cost: $544.86 ( $11.142) | Sell: $1,969.91 ( $40.283) | G/L: $1,425.05
Comm: $0.00 ( $0.000) | Comm: $0.00 ( $0.000) | Gain: 261.542%
Total: $544.86 ( $11.142) | Rec'd: $1,969.91 ( $40.283) | Gain/yr 58.423%
The report shows the purchase and sale information with the
per share amounts shown in parenthesis. The figures on the
right show the dollar gain/loss and as well as the total and
annual gain or loss as a percentage.
PAGE 35
2.2.E REPORT ON SOLD INVESTMENTS: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
At the end of the sales report you'll see a summary report
showing the total of the long term, short term, and IRA sales
for the year. If you choose the compressed report the
following note will be included in the report:
"The purchase DATE will NOT be accurate in a compressed
report if there were added or reinvested shares. The
original purchase date is shown. Avg/share and cost of
purchase are the AVERAGE cost of the investment."
2.2.F SUMMARY REPORT OF ACCOUNTS: (REPORT option # 6)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The summary report will show an overview of the selected
account (or all accounts). Of course, if you only have one
account established, this report is really an overview of the
entire portfolio. At the beginning of the report, a listing
of all the investments held in the selected account will be
displayed.
I find the report useful in analyzing how I'm doing in a
selected area as opposed to the overall portfolio. Of
particular interest to me is the growth of my IRA account.
All dollar amounts are totaled for the entire account.
If you have more than one account, and request that all the
accounts be displayed, at the end of the report, a summary
report of the entire portfolio will be displayed.
2.2.G 1099 VERIFY FORM (DIV/INTR): (REPORT option # 7)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This report was designed to be used at the end of the year
(in reality, early the following year) AFTER you have received
all your income for the proceeding year.
The report is printed in the form of a check list with a check
off place in the left column. I attempted to present the
numerical data in the manor "most" payers send their 1099's.
The report may be divided in up to four sections
1 - dividend income
2 - interest income
3 - IRA dividends
4 - IRA interest
The IRA income is presented for information only unless you
are using the IRA income as ordinary income. This is, of
course, between you and your accountant.
The gross payment amount should correspond to box 1a on the
government form 1099-DIV. Ordinary income should correspond
to box 1b, etc.
PAGE 36
2.2.G 1099 VERIFY FORM (DIV/INTR): - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assuming you entered your income correctly, your 1099's may
still disagree with your records because of the way the payer
reports the income. This usually happens with capital gains
or tax free income.
If a 1099 does not agree with your records, you should change
your records to match the 1099 using EDIT (MISC opt #1). The
1099 is, after all, what the IRS is going to accept as the
correct numbers.
TIP: To change a record select the "DIVIDEND/INTEREST RECDS"
under the edit options, select the applicable security
and record, and make the appropriate change. See
chapter 2, section 2.8.A for more on editing.
I usually select the first record for the security (if
there's more than one) and make the numbers work even
though they will NOT agree with the actual payment I
received at the time.
If you forgot to post income during the year, you may do it
now using the normal income posting options.
NOTE: The ONLY way to ALTER the past entries is with EDIT.
2.2.H RETURN ON INVESTMENT (ROI): (REPORT option # 8)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The ROI is provided as an analytical tool. The information
displayed in the report is calculated each time you request
that report. It is NOT stored in the permanent records and
therefore, if the numbers are inaccurate, it will not affect
the permanent data.
The accuracy of the numbers depend on many factors, not the
least of which is the amount of effort expended in starting
your data into the program when you first began using it. If
you used the "QUICK" method of initial data entry, the ROI's
will be inaccurate because the past income data is inaccurate
or unavailable. (see below)
The ROI/yr is the ANNUALIZED percentage return for each year
held while the TOTAL ROI is the amount returned as a
percentage of the amount invested. Money market and cash
accounts are not shown because of the file structures.
The ROI is calculated by subtracting the cost of the direct
purchases (original + added shares - but NOT re-invested
shares) from the current value. Next, the total income since
the purchase date is added, and the result is then divided by
the time held.
PAGE 37
2.2.H RETURN ON INVESTMENT (ROI): - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Using the above method allows for inaccuracies under several
conditions. In all honesty, I haven't been able to devise a
way of obtaining a more accurate figure using the existing
file structures under ALL conditions.
For example, if you owned 1000 shares of XYZ @ $10.00/sh that
paid a 10% dividend in past years, your income would be
$1,000/yr. Over the past 3 years you've earned $3,000 or 30%
total ROI. Now, as you begin the 4th year, you sell 900 shares
at $10. When the ROI is computed it will show the show the
past $3,000 as earned by the remaining 100 shares ($1,000
value). As you can see, this gives a rather distorted ROI.
It gets even more complex if shares have been reinvested. A
ratio is set up in the year of the sale which should make the
ROI closer to accurate, however, in subsequent years, after
the sales records are cleared, a ratio can not be determined
from the available records.
NOTE: ROI/yr is an annualized number. If you purchase a stk
at $1000 and sell it 3 months later at $1100 you have
an ROI of 10%, but an annualized return (ROI/yr) of 40%
What all this means is, the ROI is accurate if you don't have
partial sales of securities that are paying dividends or interest.
The ROI calculations are a best guess effort on my part. They
are presented as advisory only and are NOT recorded in any of
data files. I think you'll find them accurate if you purchase
an investment, post the income, and update the value
periodically. Once you have partial sales, past re-invested
income or any other factors, the ROI will lose its accuracy.
NOTE: If any of you mathematicians can show me how to
calculate an accurate ROI with the available data, I
shall be happy to produce an update with the new
formulas. Just contact me for the specifics of the
available data.
2.2.I BROKER TRANSACTIONS REPORT: (REPORT option # 9)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The broker report, like the others, allows you to select a
single account or report on all transactions for the year.
Most of the time, when you debit or credit the broker account
directly or through one of the other functions, you will be
asked for the tax status of that transaction.
If you indicate a debit is tax deductible or a credit is tax
free income, it will be marked that way in the records. When
you call for a broker report the tax status of the entry is
shown in the report along with a total at the end of the report.
PAGE 38
2.2.J COMBINED INFORMATION REPORT: (REPORT option # A)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
General information:
The report format attempts to present as much data as possible
on a single screen to allow you evaluate the performance of an
investment.
The menu setup allows you to create virtually any combination
of securities you may wish to evaluate from a single security
to the entire portfolio.
Any single investment that has multiple transactions will use
AVERAGE numbers for this report.
Do to rounding and averaging some numbers may not be exact and
may even differ slightly from other reports reporting on the
same item. The numbers are for reference ONLY and are NOT
entered into the records. For exact numbers use the expanded
report of the desired type.
ie. For an accurate sales report, use the SALES report (opt # 5)
The numbers shown in parentheses are the per unit amount of
the current item. Again, these ARE averages if it's a
multiple entry invest.
Example of combined report:
===>>> FIRST AUST PRIME (FAX) <<<===
======================================
Orig purch date 06/24/86 | Acct: IRA | Date last sale N/A
Last trans date 12/11/92 | Type: STK | Last inc rec'd 12/11/92
------------------------------------------------------------------
Original purch 175.000 | Sale proceeds $0.00 ( $0.00)
Add thru purch 920.000 | Cost stk sold $0.00 ( $0.00)
Add thru reinv 14.900 | G/L on sales $0.00 ( $0.00)
Num units sold 0.000 | Inc prior yrs $1,072.25
Net units held 1,109.900 | Income this yr $787.90 ( $0.71)
------------------------------------------------------------------
Original invest $1,754.44 ( $10.02) | Act yld YTD (cost) 6.32%
Cost of added $10,559.22 ( $11.47) | Act yld YTD (valu) 6.96%
Cost of reinv $147.00 ( $9.86) | Est yld on 12/ yr 5.42%
Total invested $12,460.67 ( $11.22) | Est income $675.34
Less stock sold $0.00 ( $0.00) | ROI since purch 5.69%
Cost of current $12,460.67 ( $11.22) | ROI per year 0.86%
Value 01/04/93 $11,306.55 ( $10.18) | G/L on avg cost -9.26%
G/L on avg cost $-1,154.11 ( $-1.04) | G/L on avg sale 0.00%
Specific info on selected items in the report:
Last value update:
Last date ANY investment value was updated - May NOT have
been the selected security.
PAGE 39
2.2.J COMBINED INFORMATION REPORT: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Original purch:
Number of units acquired on original purchase date. If the
investment was purchased on 2 or more buy orders this will
show ONLY those acquired on the first buy order executed.
Remainder of shares shows as "add thru purch".
Add thru purch:
All units acquired EXCEPT original purchase or reinvested
shares. The original shows in the "Original purch" while
the reinvested shows in "Add thru reinv". Usually these are
units you specifically purchased in addition to the units
you already own.
Add thru reinv:
All units acquired thru an arrangement with the payer
(usually a mutual fund) where all (or part) of your income
is used to purchase additional units in the security paying
the dividend.
Net units held:
Number of units you CURRENTLY own ((orig + added + reinv) - sold)
Original invest:
Total paid for "original purch". The cost INCLUDES the
commission (if any) you paid on the purchase
Cost of added:
The cost of any additional units acquired EXCEPT the orig
units or shares acquired thru reinvestment. This INCLUDES
the commission paid on the units. This is the cost of the
units you specifically purchased in addition to the units
you already own.
Cost of reinv:
The amounts shown are based on the AVERAGE cost per unit.
Due to rounding, the numbers may be inaccurate (± .05% error)
Inc prior yrs:
Income received prior to current year. Amount per share is
not shown as it wouldn't be useful info. This is one of the
places where the accuracy of the past income records comes
into play.
Actual AND estimated yields and income:
The actual yld YTD (cost & value) is, as the name implies,
based on what you actually have received YTD. Obviously, this
doesn't become a true annual yield until all income for the
year has been received for the security. The estimates (yld
& income) are computed by taking the average of the income
received YTD and multiplying it by the number of times you
indicated you expect to receive income each year. You may
change this number (times per year) with the Edit option
(Misc opt #1 (purchase recd's)). All the yield figures are
based on averages. If income is uneven, yields will be
inaccurate.
PAGE 40
2.2.J COMBINED INFORMATION REPORT: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ROI (Return on Investment):
Return on investment (ROI) is calculated by subtracting the
cost of DIRECT purchases (orig + added - but NOT re-invested
shares) from current value. Total income since the purchase
date is added, and the result is then divided by the time
held. ROI/yr is the % for each yr held while TOTAL ROI is
the amount returned as a % of the amount invested. Money
market and cash accounts are not shown because of the file
structures. (See Chapter 2, section 2.2.H)
G/L on avg cost:
Again, the dollar amount and percentage is based on the
AVERAGE cost of the investment subtracted from the current
value entered the last time you updated.
2.2.K INCOME HISTORY OF ONE STOCK: (REPORT option # B)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This option will allow you to view the income received in past
years. Even though the past income is used in several reports,
this and the "Expand one selected stock" option (2.2.L.f) are
the only options that will allow you to actually view the past
income data.
The report will simply report every income entry for the
investment in chronological order.
This assumes, of course, that you've been using the program
long enough to be in a second (or longer) year of use OR you
went to the trouble of entering income from past years and
then ran the "Clear files for a new year" option.
PAGE 41
2.2.L M I S C E L L A N E O U S R E P O R T S
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2.2.L.a IRS 1040 SUPPORT STATEMENTS: (REPORT opt # C, sub # 1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
General information:
The forms created were designed to be an attachment for your
income tax return for Schedule B (dividend and interest income)
and for Schedule D (Capital gains/losses).
You will be asked if you want to include IRA transactions.
Some of you may be drawing against you retirement accounts and
therefore need to report the information to the IRS.
NOTE: Most entries in a tax return are rounded to the nearest
dollar. The forms generated by this option conform to
that convention.
If you use these forms you should indicate in the appropriate
boxes on the 1040 "See attachments" and attach the forms to
the back of your return.
NOTE: This is the ONLY report that has different preparation
options depending on the output option selected for the
final report.
One option will be to view the report on the screen and
the other is to send it to the printer or a disk file.
2.2.L.a.1 PRINT TAX SCHEDULES B & D:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This function was designed to create PRINTED forms to use with
your tax return. If you send the output to a printer or disk
file, you'll have total control over the final report to assure
you of producing EXACTLY what you need (want).
You'll be asked how you want your name to appear, your SSN, if
you want to show IRA transactions, and if you would like to
REVIEW EACH LINE BEFORE it is printed.
Every effort has been made to create a form in the format that
is acceptable to the IRS as a supplemental statement to be
attached to the back of your tax return and referenced in the
appropriate boxes in the applicable schedule.
TIP: I suggest you send the report to the screen to determine
the accuracy of the numbers. If any changes are
necessary, they may be made with MISC, option 1 (edit).
You will have the option in Schedule D to combine a multiple
entry sale into ONE line using the average cost of the
investment to determine the gain or loss. Of course the
report WILL still be separated into long & short term gains.
PAGE 42
2.2.L.a.2 SCREEN TAX SCHEDULES B & D:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you send the report output to the screen you will NOT have
several options that ARE available when the report is being
prepared for a printer or a disk file.
The on screen presentation is primarily to give you an
overview of what the report will look like. It is also a good
time to verify the accuracy and make notes of needed changes
before you send it to the printer.
SUGGESTION: Even if you don't attach these forms to your tax
return, they should make a good source for the
necessary information for the completion of the
appropriate schedules in your 1040.
2.2.L.b MATURITY-CD's, BONDS, ETC.: (REPORT opt # C, sub # 2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
When you acquire a new investment and enter it through the
PURCHASE option 1, you will be asked if you want to enter a
maturity date for that investment. Of course a maturity date
only applies to certain types of investments such as bonds,
CD's, etc.
If you entered a maturity date, this report will display the
purchase AND maturity date. Investments that did NOT have a
maturity date entered will not be displayed.
The intent of this report is to allow you to take a quick
check to see if an investment is maturing.
The program does NOT automatically activate any bells or
whistles to alert you of a maturing investment. Tell me if
you would like to see automatic notification in a future
version.
2.2.L.c DISPLAY ENTERED REMARKS: (REPORT opt # C, sub # 3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All functions requesting the input of investment information
ask if you want to include a remark with your entry. Any
remark you enter will be attached to that transaction. This
will, in some instances, cause the same remark to appear in
several reports, or the same remark to appear several times in
a single report.
For instance: If you add a remark to a sale that had multiple
entries, the remark will appear attached to each entry. If
you put the proceeds of that sale in the broker account, the
same remark will also appear in the broker records.
PAGE 43
2.2.L.d SHOW NUM & % OF PORTFOLIO: (REPORT opt # C, sub # 4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This report was designed as another analytical tool. It will
calculate the current value of your portfolio and then compute
the percentage of the total for each investment you own. It
will also show the total number of units of each investment
owned.
The report does NOT separate the numbers according to the
different accounts you may have created.
If you're a proponent of a diversified portfolio, this report
will quickly show if you are tending toward having "all your
eggs in one basket".
2.2.L.e COMPARE COST TO VALUE: (REPORT opt # C, sub # 5)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Quick & dirty - you can tell a glance how your different
investments are doing. It doesn't tell you anything that
isn't available in other reports, but it does do it quick and
easy to view.
2.2.L.f EXPAND ONE SELECTED STOCK: (REPORT opt # C, sub # 6)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This report will produce the same information as an expanded
report from any of the available reports except this report
will be limited to the selected investment.
You may have a need to ascertain something about a single
investment and you don't care to generate a full report in the
subject area. An expanded report for all your investments can
grow quite large in time even with a modest portfolio.
For example, you need the purchase price of a particular stock.
When this option is selected, you will be offered a menu of
the available data with four options.
1 - Purchase records
2 - Current records
3 - Income records
4 - Sales records
After you chose the desired record information, the pick list
for your investments will appear. Just choose the desired
investment.
All the transactions on record for the selected area will be
reported.
PAGE 44
2.2.L.g PRINT REPORT FROM DISK FILE: (REPORT opt # C, sub # 7)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you have sent ANY report to a disk file, you may want to
print it sometime in the future.
To print a report that was originally sent to a disk file, you
may use the suggested DOS command that was displayed at the
end of the report generation:
C:\PM>COPY fname.TXT PRN (fname = name you assigned)
- OR -
you may use option 7 in the MISC report menu. This option
will ask for the name of the desired file to print and then
send it to your printer.
PAGE 45
2.3 P U R C H A S E M E N U
~~~~~~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
It all begins here. In order to perform ANY of the useful
functions for which the program was designed, you must enter
one or more investments.
IMPORTANT NOTE:
It is VERY important that you enter investments with the
correct menu option if you are to maintain accurate records.
Here are some general rules which will be expanded below.
1) An investment may be entered only ONCE using option #1.
2) If you BUY additional shares, use option #2.
3) If you acquire shares through a stock split or stock
dividend use option #3.
4) If you acquire shares through re-investment use the
INCOME function from the main menu.
SUGGESTION: If, during a calendar year, you purchase a stock
(IBM for example), sell the stock, then later, during
the same calendar year, re-purchase the same stock, I
suggest you alter the name to distinguish the re-purchase
from the original purchase (IBM-2 for example).
Although the re-purchase above WILL be kept separate, if you
were to sell the second purchase, the sales report could be
confusing to read.
2.3.A ENTER A NEW INVESTMENT: (PURCHASE option #1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
USE THIS OPTION ONLY ONCE FOR EACH INVESTMENT YOU ACQUIRE
=========================================================
Use this option for the initial acquisition of an investment.
If you increase your holding in a particular investment, use
the appropriate function to reflect the change.
When selected, the option presents a screen requesting
information on the new investment. As you complete the form
on the screen, an instruction window will appear on the right
giving specific instructions for the requested item. Some
items require you select from a menu of possible responses.
ie. type, exchange, account, etc.
Most items should be self explanatory, however, consider the
following:
EXCHANGE SYMBOL: Not required, but enter it if you know it.
At the present it isn't used, however, I hope to add a modem
download capacity to the program in the future at which time
it will be needed.
PAGE 46
2.3.A ENTER A NEW INVESTMENT: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
COST PER UNIT: If you enter a bond purchase you MUST enter
the cost in the same format as shown in financial journals.
ie. 10% of the actual price
If you enter the full price per bond, the cost in your
portfolio will show 10 times higher then it's supposed to be.
example: you purchase a bond with $1,000 face value for $987.25.
Enter the purchase cost as $98.725 per bond. This
conforms to the way it's reported in the newspapers.
TOTAL COMM & MISC: Always enter the FULL amount paid for ALL
the extra charges OVER the basic cost of the investment. All
charges such as commissions, taxes, misc, etc. should be
included in this figure. The program will enter the per unit
cost of the amount paid for future use.
NO. DIV/INTR PER YR: The entry routine requests the number of
income payments you expect to receive each year. This number
is used to calculate the estimated yields. If you enter an
incorrect number, the estimated yields will be distorted. If
you enter a zero (0) and then receive an income payment(s),
the program will always treat it as one payment per year for
yield calculations.
MATURITY DATE: If your investment is the type that has a
maturity date (bonds, CD's, etc.), you may enter it here. It
will be used to produce a report showing the maturity dates.
2.3.A.a CONSTANT VALUE INVESTMENTS:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The second item on the entry screen is the type investment and
the seventh option (7) in the pop-up menu is "Constant val".
NOTE: If you select the type as "Constant val", the TYPE will
be coded a "MMA". This is strictly for internal use and
has no relation to the actual investment type.
Many investments may be considered to hold a constant value
(ie. will not fluctuate in market value) such as Money Market
Accounts (MMA's), Cash Reserve (CR's), etc. Other type
holdings COULD be treated as constant value investments such
as savings accounts, CD's, annuities, limited partnerships, etc.
My theory is that any investment can be reduced to $1.00 units
(and fractions of a unit to represent cents). You may then
acquire enough units to equal the actual dollar value of the
investment.
NOTE: Do NOT convert the other way - one unit at the dollar
value of the investment. This would make it difficult
to reinvest dividends, show gain or loss properly, etc.
PAGE 47
2.3.A.a CONSTANT VALUE INVESTMENTS: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lets try a few examples of how to apply this theory:
A savings account: Your current savings account balance is
$5,345.36. Enter as 5,345.36 units (shares ??) at $1.00 per.
If your account is credited with $23.85 interest, enter it
using the INCOME option and then the PURCHASE opt #2 to "add"
23.85 units at $1.00 per. Your income earned will be reported
properly through the income reports. If you withdraw $500.00
from the account, enter it as a regular sale of 500 units at
$1.00 per share. This will NOT affect your sales gains or
losses because you bought AND sold at the same price.
A limited partnership: You buy into a limited partnership
for $10,000. Enter 10,000 units at $1.00 per unit. If you
receive a cash distribution, show it as a normal dividend.
When you sell (liquidate), enter it through the sales option
as a number of units equivalent to the amount received a $1.00
per unit. As you can see, this will reflect your true gain/loss.
A Certificate of Deposit (CD'S): Treat similar to the above.
If you roll it over to a new CD, treat it as a sell and then a
new purchase. The interest received on the original purchase
should be entered as an ordinary interest payment through the
income option NOT as a gain on the sale of the CD.
So, to sum the theory and use this program to cover almost any
type investment, break it into $1.00 units, enter ALL income
through the INCOME option, any increase (deposit) to the
holding with the "Add shares to stock you own" option, and
any reduction to the investment through the SOLD option.
Treat it all at $1.00 per unit.
NOTE: If after you enter a new investment, you run a CURRENT
VALUE report, you may notice a difference between the
cost and current value of the new investment. This is
because, if you paid a comm/misc charge, the per share
amount of the comm/misc has been added to the cost of
the security for the report.
PAGE 48
2.3.A.b BOND INTEREST BUY OR SELL:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bond interest (if any) that is paid as part of the purchase of
a bond will be entered as negative interest income. By
treating it as negative income (will have minus sign), it
causes the bond in question and the total interest income to
show accurate numbers for the income reports.
The current IRS codes (1992) allows interest paid on a bond
purchase to be used to offset the income earned on that bond.
If you don't receive the bond interest until the following
year, you may use the interest expense to offset other similar
interest received during the current year. I suggest you
check with your tax advisor for a more definitive ruling.
Interest received when you sell a bond will be posted to the
income records as regular interest income.
NOTE: The interest will be posted through the sell function
and should NOT be entered through the regular income
option to be sure it is NOT posted twice.
In both cases (buy or sell) you will have the option to NOT
have the interest posted as described above. This option will
appear at the end of the function.
2.3.B ADD SHARES TO STOCK YOU OWN: (PURCHASE option # 2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you purchase additional units of an investment use this
option to enter them into the records.
SUGGESTION: Do NOT use this option to enter shares acquired
through the re-investment of dividends. Use the
INCOME option and indicate that the income is to
be re-invested.
You could show a re-invested dividend by entering it as a cash
dividend with the INCOME option and then adding the appropriate
number of share with this option. If you use this approach,
your totals will still be accurate but the source of shares,
and the ROI will NOT be accurate.
When selected, you'll be shown a pop-up menu with a list of the
investments you currently own. Select the desired investment.
The next screen will show a listing of the current holding and
an entry form for the current purchase.
When the form has been completed, you'll be asked to confirm
your entries. The updated data will be shown in the top
right of your screen. If you made a mistake you will have the
option to edit or cancel the entries.
PAGE 49
2.3.C ENTER STK SPLIT OR STK DIV: (PURCHASE option #3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If a security you already own declares a stock split or a
stock dividend use this option to enter the newly acquired
shares. It is NOT for stock acquired through re-investment.
NOTE: Do NOT use this option if the stock was acquired due to
a merger or buyout of the corporation (see sect 2.3.G)
When selected, you'll be shown a pop-up menu with a list of the
investments you currently own. Select the desired investment.
On a stock split or stock dividend, the cost of the new stock
is usually entered as zero (0). If you enter a zero (0), the
cost basis of the entire holding will be adjusted to reflect
the new cost basis of the entire investment.
When the form has been completed, you'll be asked to confirm
your entries. The updated data will be shown in the top
right of your screen. If you made a mistake you will have the
option to edit or cancel the entries.
2.3.D SELL A STOCK SHORT: (PURCHASE option #4)
~~~~~~~~~~~~~~~~~~~~~~~~~~
A short sale is the sale of a security you don't own with the
promise to supply (acquire) the actual shares at a later date.
The entry form for a short sale is identical to the entry form
"Enter a new investment". I suggest you review section 2.3.A.
While a short sale is open, the purchase and current value
reports will list the security and the number of shares but
with a zero (0) cost as the basis and no purchase date. The
sales report will show the sale as a gain of 100% of the
invested amount since the cost basis at this point is zero(0).
2.3.E COVER SHORT SALE POSITION: (PURCHASE option #5)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You can NOT cover a short sale if there are none. If you
select this option with no short sales on record, you'll be
told "there are no short sales" and returned to the main menu.
The form for covering is the same as used in "Add shares..."
or "Enter stk split...". Complete the form as you would the
above mentioned forms.
When the form has been completed, you'll be asked to confirm
your entries. The updated data will be shown in the top
right of your screen. If you made a mistake you will have the
option to edit or cancel the entries.
After the short sale has been completed, the reports will
appear as you would expect. The purchase report will no
longer carry a record of the position and the sold report will
show the normal information for any sale. It will reflect
your true gain or loss on the transaction.
PAGE 50
2.3.F ADJUST ORIGINAL COST BASIS: (PURCHASE option #6)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
There are several reasons the cost basis of an investment may
be changed. Most of them are done automatically in other
functions, however, if you need to change the cost basis and
it isn't covered elsewhere, this option is available.
A "Return of Capital dividend" should be done from the INCOME
menu (option #3). A stock split or stock dividend should be
done from the PURCHASE menu (option #3) to adjust the cost basis.
A use for this option might be an incorrect initial broker
confirmation slip.
Use of this function is very simple. After you've selected
the desired security you will be asked to enter the new cost
per unit or press enter to retain the original cost.
If you enter a new amount, the ORIGINAL cost of the security
will be change to the new amount.
NOTE: If you acquired additional shares through subsequent
purchases or share re-investment the cost of the
additional shares will NOT be changed. Use edit if
these shares should also be changed.
2.3.G ADJUST FOR MERGER OR BUYOUT: (PURCHASE option # 7)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If a company in which you own stock is merged or bought by
another company, use this option to make the necessary changes
to the records.
The module assumes that you'll receive an exchange ratio for
your original shares. Enter the RATIO you receive NOT the
total number of shares. The program will compute the adjusted
number of shares you own.
WARNING: You MUST enter the ratio of original shares NOT the
number of new shares you now own.
ie. 1.75 share for ea share you own
ie. .5 share for ea share you own
If, in addition to the share exchange, you receive a cash
distribution, it should be entered as cash received. It'll be
recorded as tax free income (return of capital payment) and be
shown in the income report.
By implication, the name will be changed. If you answer YES
to the name change question, the name change will be done to
ALL of the files where the original name appeared.
PAGE 51
2.4 U P D A T E V A L U E S M E N U
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To update the current value of your investments you must enter
the current price into the records from an outside source such
as a newspaper, broker report, etc. The information, when
entered, will be stored into the permanent records.
NOTE: If you enter a new investment on which you paid a
commission, the current value will show as the cost less
the commission paid on the purchase until you update
the current value.
There are 3 different formats you may use to enter the new
current price.
1. Quick form - Will step thru each investment sorted by
exchange and then alphabetically. It'll present a
minimum of information about the investment and request
the new price. It will show the new total value and ask
you to confirm the entry. To accept the current value
as shown, press the Enter (return) key.
2. Long form - ALL: Same as 1 above except it will offer
considerably more information about each investment as it
appears on the screen.
3. Long form - SELECT: Like 2 above, it offers considerably
more information about the selected security. This option
will present a pop-up menu with all the investments listed.
Select the desired security and press Enter. This option
was designed to update just a few selected investments.
NOTE: If an investment has multiple entries because of re-
investments or added purchases, ALL the entries for
the selected investment will be updated.
NOTE: If ANY value is updated, the date of the update is
stored and shown in several reports as the date of the
last update EVEN if only ONE investment was updated at
the time.
PS: I've had requests for a communications module to allow
updates through a modem service (Dow Jones, Genie, etc.).
To be quite honest, I don't know how to program it. I'm
making an effort to learn but, so far, I haven't been
able to create anything reliable (no bugs). If any of you
are knowledgeable on the subject and willing to help,
PLEASE contact me. As soon as I develop a module I'll
release it to the registered users.
PAGE 52
2.5 I N C O M E M E N U
~~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Any income you receive from your investment should be entered
with the income module. There are a few exceptions to this rule:
1) Interest received as part of the sale of a bond will be
entered through the SOLD option. (See Ch 2, section 2.7)
2) Income (distribution) received as part of a buyout or
merger is entered through the PURCHASE option.
(See Ch 2, section 2.3.G)
When you choose the income option from the main menu you will
activate a pop-up menu with a listing of your investments.
NOTE: Sold securities are listed in the pop-up menu until you
use MISC option #6 "Clear for a new year" to clear the
files. This is to allow you to post income received
AFTER an investment has been sold.
After you've select your choice, the screen will show, in the
top left, a window with basic information on the selected
investment. Use this to confirm that you've selected the
desired investment.
The top right of the screen will show information about the
income history for the selected investment. If investment has
NOT received income in the CURRENT year, a note will be in the
window to that effect.
In the lower half of the screen will be a menu with the income
options. ie: Dividend, Interest, or Return of Capital.
If the normal type of income is a dividend as with a stock,
the "DIVIDEND..." option will be highlighted. If the normal
payment is interest as with a bond, the "INTEREST..." will be
highlighted.
If you select interest where a dividend is expected or visa
versa, a warning window will appear asking you to confirm your
choice. You may confirm the switch if that's the case.
PAGE 53
2.5.A DIVIDEND INCOME: (INCOME option #1)
~~~~~~~~~~~~~~~~~~~~~~
The dividend function will ask if the income is to be re-
invested. A default response, "YES" or "NO", will be
highlighted depending on how you responded to the "Set default
response" question in the configuration menu (MISC opt #9,
CONFIGURE opt #5).
NOTE: If you are making a PARTIAL re-investment of the income
(usually through a mutual fund), you MUST enter the
dividend as TWO SEPARATE entries.
Make one entry as the re-investment using the amount of
the dividend that has been re-invested. The other entry
should be for the cash portion of the dividend.
This situation will arise if you designate a re-
investment of capital gains but have the dividends paid
in cash. In this situation you MUST use TWO SEPARATE
entries to post the income.
After you respond to the "re-invest" question, a data entry
screen appears. Consider the following in completing the entry:
DATE: If you enter a date that differs from the "active data
year" (See Ch 2, section 2.0.E) the function will question
the entry. The income function expects you to enter the
current RECORD year. You may confirm your entry or have the
opportunity to re-enter the date.
NOTE: PM maintains a reference (record) year in the
PMMEMORY.MEM file. This allows you to post entries in
January (or later) of a subsequent year without being
challenged. The internal reference year is reset to
the calendar (computer) year when you run the "Clear
for a New Year" option in the MISC menu (option 6).
TAX FREE & CAPITAL GAIN: If the full amount of the payment is
tax free or capital gains (or both), you may use the '+' sign
to have the FULL entered payment amount enter automatically.
If neither applies, press Enter (Return). It will default to $0.
No. OF SHARES: If, at the start of the function, you indicated
that you were re-investing, enter the number of shares here.
The cost per share will be calculated. If the calculated cost
per share is more than ± 25% different from the average cost
per share, your input will be challenged.
NOTE: If you indicated a re-investment, you may NOT enter a
zero as your response. If you intend to NOT re-invest,
use the ESC key to exit and start over again.
If you choose to NOT re-invest the payment, the "No. of shares"
input line will NOT be activated.
PAGE 54
2.5.A DIVIDEND INCOME - (continued)
~~~~~~~~~~~~~~~~~~~~~~
After you've completed the "entry form" an "Updated income
report" window will appear in the lower right corner. You will
be asked to confirm your entries. If all is correct, press
enter to confirm. If there is a mistake, a "NO" response will
allow you to edit the entries OR you may cancel.
If you confirm your entries AND you indicated that you did NOT
re-invest the payment, you'll be asked if you want to credit
the broker account (See chapter 2, section 2.0.J).
SUGGESTION: I recommend you use the broker account for every
monetary transaction to provide a paper trail for your
funds. Enter the payment with the income option.
Later, use the BROKER option to debit the broker
account for the same amount (with a remark ??). Why ???
While the income report will show that you received the
income, the broker report will show where it went (and
it certainly does seem to go !!!!).
2.5.B INTEREST INCOME: (INCOME option #2)
~~~~~~~~~~~~~~~~~~~~~~~
Entering interest income is similar to entering dividends.
Note the following differences:
You will NOT be asked about re-investing the payment.
SUGGESTION: If you are using my theory on "constant value
investments" (See Ch 2, section 2.3.A.a) and you wish
to leave the earned income with the investment such as
with savings account interest, enter the payment here
as a regular interest payment and credit the broker
account with the amount of the income at the end of the
routine. When you've finished entering the income, use
the PURCHASE opt # 2 to purchase (ADD) a number of units
equivalent to the amount of the payment @ $1.00 per unit
and debit the broker account to pay for the purchase.
You will NOT be asked to input a capital gain amount.
2.5.C RETURN OF CAPITAL DIVIDEND: (INCOME option #3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
A return of capital dividend is usually tax free income that
requires an adjustment to the cost basis of the stock by the
amount of the dividend.
Enter the dividend as you normally would. (See Ch 2,
Section 2.5.A).
After the entry has been completed (after "credit broker"
question), you'll be asked if you want to adjust the cost
basis of the investment. The amount of the adjustment will be
calculated and displayed on the screen. If you answer "YES"
the purchase cost will be changed by the amount indicated.
PAGE 55
2.6 B R O K E R M E N U
~~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Selection of "Broker" from the main menu will allow you to
make a direct entry to the broker records. This feature is
primarily used to enter broker interest or margin charges. It
may also be used to record funds sent to, or received from,
your broker.
When you select "Broker", you'll have the option to debit,
credit, or display a brief summary of the current balances for
each account you established with the configuration program.
Regardless of the method of access you'll be asked the tax
implication of most transactions. The full broker report will
be divided into taxable and non-taxable entries to ease the
preparation of your tax returns.
2.6.A & 2.6.B DEBIT/CREDIT BROKER CASH ACCOUNT: (BROKER opt #1 & 2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you indicate a debit or credit the broker account you'll be
asked to select which of your accounts the transaction will
affect (if you have more than one account). Use the bar menu
to select the desired account.
Enter the amount of the transaction.
You will be asked to enter "Credit source" for credit entries
and "Type expense" for debit entries.
NOTE: This is should be used like a comment field. I suggest
a short phrase such as "Margin interest" or "Funds
deposit". This field will be shown in the reports to make
them more meaningful when read in the future. You will
still have the option of attaching a remark to the record.
If you're posting a debit, you'll be asked if it is a tax
deductible expense (yes or no). If its a credit, you'll be
asked if its taxable income. Your response will be reflected
in the full broker report.
Enter the date of the transaction. Since most transactions
will be entered after the fact, I suggest you use the actual
transaction date rather than today's date.
2.6.C REVIEW BROKER ACCT BALANCE: (BROKER opt #3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You may create a quick summary of your account balances. This
option will show the balance in each of your established
accounts and a total of all the accounts. For a full broker
report, use the Report menu, option #9.
PAGE 56
2.6.D BROKER ACCOUNT WITH TRANSACTIONS:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Almost every transaction that involves money asks if you want
to debit or credit the broker account.
If you respond "Y" (Yes) or click the mouse on Yes, you'll
be asked how much, where appropriate, and the amount you enter
will be posted to the broker records.
The amount will default to the amount of the transaction and
the program will not let you enter an amount that exceeds the
amount of the transaction.
Of course, you may still debit or credit the broker account
directly with the broker function
SUGGESTION: I recommend you use the broker account for every
monetary transaction to provide a paper trail for
your funds.
Why ??? While the income report will show that
you received the income, the broker report will
show where it went (and it does seem to go !!!!).
Example: You receive a dividend check from a stock. Enter
it with the INCOME option and credit the broker
account when asked. Next use the BROKER option
and debit the broker account for the same amount
(with a remark ??).
PAGE 57
2.7 S E L L M E N U
~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Selling your complete interest in an investment is a simple
and direct entry. If you're selling part of a holding with
multiple records, it gets a bit more involved. See "Partial
sale of an investment" below for information on how to enter
a partial sales.
Select the desired investment from the pop-up menu of all your
current investments.
The top left of the screen will show the "Basic information"
on the security and the top right window will show any
"Additional info" relevant to the selected security. You
will be asked to confirm your selection.
If you confirm the investment selection, a window in the lower
center of the screen, "Sale entry form", will request the
pertinent information regarding the transaction. You'll be
asked for the transaction date, the price per share, the
number of shares sold, the total comm/misc paid, and any
accompanying remarks. If the sale involves a bond, you'll
also be asked to enter the amount of interest you received as
part of the transaction.
The "Sale price/shr" is entered as the GROSS amount received
per unit sold.
IMPORTANT NOTE: If you enter a bond sale you MUST enter the
selling price in the same format as shown in financial
journals. ie: Use the same format you used when you
acquired the initial investment.
ie. 10% of the actual price
If you enter the full price per bond, the sale proceeds
shown in your portfolio will show 10 times higher then
the correct amount
example: you sell a bond with $1,000 face value for $987.25.
Enter the sale price as $98.725 per bond. This
conforms to the way it's reported in the newspapers.
To sell your entire holding in the selected investment, press
enter (return) when ask "No UNITS SOLD:". This will default
to the number of units shown at the bottom of the window which
is the total of ALL the units held for the selected investment.
PAGE 58
GENERAL INFORMATION - (continued)
~~~~~~~~~~~~~~~~~~~
When entering the "Comm/misc" always be sure to enter the TOTAL
amount that was deducted from the gross amount of the sale.
ie. Commission + tax + misc + etc.
The per unit commission will be calculated and entered into the
records for use in reports.
If the sale involves a bond, you'll be asked to enter the
amount of interest you receive in the selling transaction.
See Ch 2, section 2.3.A.b (Bond interest buy or sell) for
additional information.
Bond interest (if any) that was paid as part of the purchase
of a bond was (or should have been) entered as negative
interest income. By treating it as negative income, it causes
the bond in question and the total interest income to show
accurate numbers for the income reports.
The current IRS codes (1992) allows interest paid on a bond
purchase to be used to offset the income earned on that bond.
If you don't receive the bond interest until the following
year, you may use the interest expense to offset other similar
interest received during the current year. I suggest you
check with your tax advisor for a more definitive ruling.
Interest received when you sell a bond will be posted to the
income records as regular interest income.
NOTE: The bond interest received as part of the sale will be
posted through the sell function and should NOT be
entered through the regular income option to be sure it
is NOT posted twice.
In both cases (buy or sell) you will have the option to NOT
have the interest posted as described above. This option will
appear at the end of the function.
PAGE 59
2.7.A SELL AN INVESTMENT (all the shares):
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you're selling your complete interest in an investment or
you're selling part of an investment with a SINGLE purchase
record, the transaction entry is almost complete.
After the request for a remark, a "Verify sales data" window
will appear in the lower right corner of the screen. You'll
be asked to confirm the data shown in the window on the right
in a window in the lower left of the screen. The right window
will also indicate the availability of the F5 function key to
show how the data was derived.
SUGGESTION: You may press the F5 key at this time to see an
example of how the results of the sale gain/loss was
calculated using the numbers YOU just entered.
If you confirm the sale, you'll be asked if you want to credit
the broker account. If the numbers are incorrect, you'll have
the opportunity to edit the entry or cancel with the ESC key.
NOTE: Again, as I do throughout the manual, I suggest you pass
most transactions through the broker account. If you're
going to receive (a check) and use the proceeds, all you
would have to do is issue a debit to the broker account
from the broker menu to be back to the true balance.
2.7.B SELL PART OF AN INVESTMENT:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you plan to sell part of an investment with multiple records,
you have considerable control over which records will be sold.
Multiple records are produced when you acquire additional shares
through re-invested dividends or through direct purchase after
the initial purchase.
The example setup:
You purchased 100 shares of XYZ fund which pays a monthly
dividend. The dividend is re-invested and buys 3 new shares
a month. After a year you own 136 shares and decide to sell
40 shares. (don't try to figure a yield - it's an example)
This investment produced 13 entries (records). The original +
the 12 re-invested dividend entries.
I feel one of the strong features of the program is the
ability to select the shares you want to sell in a situation
like the example.
The sale is entered as any sale would be entered (as shown
above). After the request for a remark, a "Verify sales data"
window will appear in the lower right corner of the screen.
The window will contain, in the first line, a suggestion that
you use the F5 function key for information and an example of
the sale using YOUR data. I suggest you use the F5 key to
look at the example YOUR data with the current numbers.
PAGE 60
2.7.B SELL PART OF AN INVESTMENT - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The "verify sales data" window
------------------------------------
1 | SEE "F5" FOR AN EXAMPLE |
2 | BUY DATE PRICE UNITS VALUE |
3 | 01/04/92 10.000 100.000 11.000 |
4 | |
5 | #TO SELL (─┘=xxx.xxx): _________ |
6 | |
7 | REMAINING UNITS TO MARK: yyyy.yyy |
--------------------------------------
xxx.xxx = Units that may be sold from current record
yyy.yyy = Units still needing to be marked as sold
The record shown in line three will be the first record for
the security. The program will cycle through units on record
until you mark a number of units equal to the number you
indicated were sold.
Each time you enter a number on line 5, line 3 will change to
the next record and line 7 will reduce yyy.yyy by the number
of units you just marked.
xxx.xxx in line 5 will change to the number left to be sold
(the same a line 7) - OR - all the shares shown in line 3.
xxx.xxx will be which ever is smaller, shares left to mark
- OR - available for sale in that record.
If you do NOT want to sell any shares from the current record,
enter a 0 (zero) in line 5 for the record. The program will
skip to the next record.
Using this selection process you may use a FIFO or LIFO method
of unit sales (assuming units were acquired at intervals over
a period of time). As the program steps through the shares
owned (in order of acquisition), you may mark all, some, or
none of the records. Marking the securities in the order
acquired is not necessary.
NOTE: You may select ALL or PART (up to the number you sold)
of EACH record. This will allow you to determine the
tax consequence of a sale (long or short term). The
program will continue to loop through the records UNTIL
you select enough shares to cover the number you
indicated were sold.
The partial sale of securities is really not so complicated.
If you make a partial sale of a security with only one record,
the entry steps are identical to the steps used to sell an
entire holding. If the investment has multiple records, the
program loops through the records allowing you to select which
shares (parts) of the sold security you want to sell.
PAGE 61
2.7.C THE TREATMENT OF BOND INTEREST:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you are selling a bond, the interest received as part of
the sale should be entered as part of the sale entry.
NOTE: Enter BOND interest received with the sale of a bond
when asked on the sale entry form, NOT with the income
option. This applies bond interest ONLY.
If the investment being sold was coded as being a bond, an
input field will be shown in the window requesting you to
enter any interest paid as part of the sale process.
NOTE: Be sure to enter the selling PRICE of the bond as it is
shown in the financial journals. ie. A $1,000 face
value bond that is sold for $1005.45 is entered with a
selling price of $100.55.
2.7.D COVERING SHORT SALE:
~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you sell a stock short (sell a stock you do not yet own),
you MUST use Purchase opt #4.
The entry of the transaction is very similar to the procedure
followed for the purchase of a new investment but it will be
coded internally as a short sale.
The entry form for a short sale is identical to the entry form
"Enter a new investment". I suggest you review section 2.3.A.
While the short position is open, the sales report will
reflect a gain of the entire amount which was received for the
short sale.
To cover the position, use Purchase opt #5. The security
selection menu will appear but show ONLY the securities which
have been sold short. If there are NO short sales active, a
message window will inform you of that fact.
When the selected security appears, enter the requested data.
The sales report will now reflect the appropriate gain or loss.
PAGE 62
2.8 M I S C E L L A N E O U S M E N U
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The miscellaneous functions allow you to perform various
maintenance and record keeping functions.
Each menu item will provide a one line description of its
function on line 23 of the screen. Move the cursor through
the menu with the arrow keys to view the descriptions.
AFTER an item HAS BEEN SELECTED by placing the menu bar on the
desired function and pressing Enter (or using a mouse to
point and click), a help screen will be available (F1) with
specific information on the selected function.
2.8.A EDIT/CHANGE/VIEW A RECORD: (MISC, option #1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Use the edit options with CAUTION. They were included to
allow the user to alter the basic records. When you first
select the option, a "WARNING" window will appear asking if
you want to continue.
TIP: I STRONGLY RECOMMEND you BACKUP the data files before
proceeding.
TIP: I suggest you review the glossary in Ch 3, sect 3.F
for an explanation of the terms used in this procedure.
Many securities have multiple entries. Some fields (ie. name,
acct, etc.) MUST be changed in EACH data file to be consistent
for the security. If you change one of these fields in a data
file, examine the other files to see if the field also needs to
be changed (or was changed automatically) in that file as well.
ex. If you change the account name for XYZ stock in the
purchase records, be sure it is also changed in the income,
sold, and broker records (if any of them are applicable).
First you'll be asked which data file you want to edit. Use
the arrow keys (or point & click) to select the file you want
to edit.
1 - Main purchase records
2 - Dividend/interest records
3 - Security sales records
4 - Broker cash/margin account
PAGE 63
2.8.A EDIT/CHANGE/VIEW A RECORD: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Next, you'll be asked to which function to use.
1 - Edit (change) a record
2 - View (no changes) records
3 - Security name change ONLY
4 - Foxpro(tm) "browse" file
Use Opt #1 to alter (edit) the data in a record.
If you want to examine the records WITHOUT making any changes,
use opt #2. This will allow you to see the data in a record
without making any changes. This is a useful feature in that
it lets you locate and examine the data before you make any
actual changes.
If a company changes it's name, and there are NO other changes,
use option #3. Option #3 is exactly the same as option A in the
MISC menu. The original name change function was in the edit
options (here) but users were having trouble finding it so I
gave it its own position in the menu but saw no reason to
delete it from the edit menu. Option #3 or MISC opt "A" will
assure that the name is changed properly in all the files.
NOTE: If you activated "browse" in the configuration menu,
you will see a 4th choice, "Foxpro(tm) browse file".
CAUTION: Do NOT use browse unless you're familiar with xbase
type "browse" function. See ch 2, sect 2.8.I.l
The next screen will offer a pop-up menu with a listing of the
investments in the data file you selected. Move the menu bar
to the desired investment and press enter (return).
If the selected investment has multiple entries, you'll have
an opportunity to step through each record that is part of the
SELECTED security until you find the record you want to edit.
Use the PgUp/PgDn keys to move through the records for the
selected investment.
If the investment has only one entry, it will appear on the
screen ready to edit.
After the security has been selected, there will be limited
instructions on the screen to help you edit the record.
To edit, use the arrow keys to move the bar up or down the
list of fields (items). When you've high-lited the desired
field, press enter. You are now (finally) ready to make a
change to the record.
After making the change, you will have the first of several
chances to confirm the change.
PAGE 64
2.8.A EDIT/CHANGE/VIEW A RECORD: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
After you enter the change to the selected record, you'll be
asked if you want to make more changes to THAT record. This
question refers to the information you see on the screen. You
may edit other fields in the selected record if desired.
When you're finished with the selected record you'll have a
chance to change other records for the selected investment (if
it's a multiple entry security).
NOTE: If the interest amount is changed on a bond purchase or
sale, the interest change will NOT be automatically
entered or changed in the income records as it is when
you use the regular buy/sell function. Use the regular
"income" function to post the interest.
NOTE: All the edit functions will be performed in a temporary
file create for this purpose. At the end of the edit
function (when you exit) you will have the opportunity
to save or cancel the changes. BE -SURE- THE CHANGES
ARE AS YOU WANT THEM. THE ORIGINAL FILES WILL BE
PERMANENTLY CHANGED. !!!
SUGGESTION: When you EXIT the edit option, if you made ANY
changes to the records, you will be asked if you want
to perform a validity test on the data files. I
suggest you respond "YES" to the question to verify
that any changes you made did NOT cause a problem in
the format or content of the data files.
TIP: The edit function is NOT bullet proof but is also NOT
as complex as it may sound. Review the glossary in
chapter 3 for the terms record, field, file, etc. Keep
in mind that we have to zero in on the desired record
and field and then make the appropriate changes before
moving to another record. EVERY step of the way offers
the opportunity to cancel.
PAGE 65
2.8.B DELETE AN ENTRY FROM RECORDS: (MISC, option #2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Use the option with CAUTION. When you select the option, a
"WARNING" window will appear asking if you want to continue.
TIP: I RECOMMEND you BACKUP the data files before proceeding.
Record selection is identical to selecting a record when you
indicate you want to EDIT a record. I suggest you review the
above (section 2.8.A) on selecting a record.
First you'll be asked which data file has the record(s) you
want to delete. Use the arrow keys (or point & click with a
mouse) to select the appropriate file.
Select the desired investment from the list. If the security
has multiple entries, you WILL have the opportunity to step
through each record for the selected security until you select
the record(s) you want to mark for deletion.
If the investment has only one entry, it will appear on the
screen and ask you to confirm that it is the record you want
to delete.
If the selected security has multiple entries, you may use the
PgUp/PgDn key to step through the records of the security.
You may mark one or more records to be deleted by pressing
"enter" (return) when it is on the screen. You will be asked
to confirm your choice.
When you indicate that you've marked all the records you want
to delete, you will be asked to confirm your selections.
NOTE: You'll be asked a second time to confirm the deletions.
Once the data is removed (deleted), it can NOT be
recovered except through the use of your backup files.
SPECIAL NOTE: If you've marked a record to be deleted and
then you change your mind, you should select the same
record again. The function will ask if you want to
"un-delete" the record. ie: If you select a deleted
record, you'll be asked if you want to un-delete it.
NOTE: The delete function will be performed in a temporary
file created for this purpose. At the end of the
delete function (when you exit) you will have the
opportunity to save or cancel the deletions. BE SURE
YOU HAVE DELETED ONLY THE RECORDS YOU PLANNED TO DELETE.
THE MARKED RECORDS WILL BE PERMANENTLY REMOVED. !!!
SUGGESTION: When you EXIT the delete function, if you removed
any records, you'll be asked if you want to perform a
validity test on the data files. I suggest you respond
"YES" to the question to verify that any changes you
made did NOT cause a problem in the format or content
of the data files. (see section 2.8.C)
PAGE 66
2.8.C TEST & FIX DATA &/OR MEMORY PROBLEM: (MISC, option #3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
***** N O T I C E *****
PRIOR TO CONTACTING ME FOR ASSISTANCE, PLEASE RUN THE FILE
TESTS AVAILABLE IN THE "MISC" MENU, OPTION #3. THIS TEST WILL
RESOLVE MANY OF THE PROBLEMS THAT ARE RELATED TO DATA FILES.
TIP: The file testing procedure may be used any time from the
MISC menu. I suggest using it periodically to verify
the data and index files are in order. You should also
consider using the automatic test feature which may be
activated from the configuration menu. See sect 2.8.I.m
The testing function will NOT make ANY changes to the data
files without YOUR consent.
It will be activated automatically after the use of certain
other program procedures such as backup recovery.
The file test procedure performs the follow functions:
1 - Verify that all the required data files are present.
2 - Test and update the index (see glossary) files.
3 - Test totals (gross values) in the data files to be sure
they're in balance when the data is interrelated across
several data files.
4 - Test for the presence of a zero (0) in a field (see
glossary) where a zero doesn't belong (a zero in a
wrong field will cause a program crash by attempting
to divide by 0).
5 - Test for proper coding needed to find an investments.
6 - Test if account names in the memory file matches the
account names in data files.
7 - Test if each investment has a unique number.
An explanation of the file test procedures listed above:
1 - The program uses 5 data files as follows:
1 - PMPURCH.DBF (purchased, added, or re-invested investments)
2 - PMSOLD.DBF (record of sales)
3 - PMDIV.DBF (income records - current year)
4 - PMDIVOLD.DBF (income records - past years)
5 - PMBROKER.DBF (all broker transactions)
Also used is a file that stores the information you were
asked to provide when you configured the program such as
your name, accounts, etc. This file is named PMMEMORY.MEM.
If any of these files are missing the program can't continue.
NOTE: If, for any reason, you need to send me your data
files to fix a problem, I will need the six files
named above.
2 - The index files are used to locate data. If they are out
of sequence with the data file they index, a problem will
occur. All index files end with the extension ".IDX".
PAGE 67
2.8.C TEST & FIX DATA &/OR MEMORY PROBLEM: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 - A gross value of an investment is maintained in a data
file. If the gross value is not accurate, some of the
analytical data the program offers will not be accurate.
4 - In certain fields, a zero value would make the applicable
record meaningless. It will also cause a problem if the
program attempts to use it.
5 - Every investment MUST have at least one record coded with
a "B" (for internal use) in the purchase records, or the
program will NOT find the investment although it is still
in the file. This function will test for the proper codes.
6 - Account names are stored in a memory file (PMMEMORY.MEM).
Any SHORT account name in the data files that does NOT
match one of the names from the memory file will NOT be
found when called. This test will determine if all the
short names in the records matches a name from memory.
7 - Each investment MUST have a unique ID number. If two (or
more) investments share the same number, only one investment
will appear when called. This option will test for dups.
If a problem is encountered, a window will be activated with
information about the problem and the recommended action to
resolve it.
If a problem is found during the file testing, I recommend you
review the data to see if it can be found and resolved using
the edit option. If possible, you may want to use your backup
files to recover data.
NOTE: In most cases, when a problem is discovered, you'll be
given an opportunity to repair it. If you elect NOT to
fix the problem with the programed fix, editing the
data, or recovering data from your backup files, the
problem WILL be noted EVERY time you run the file tests.
SUGGESTION: Do NOT answer "Y" to "BACKUP DATA" question on
the opening screen until you check the data. The
problem usually isn't serious and may have been caused
by back-up recovery, editing, deleting or tests.
NOTE: The configuration module (MISC opt #9) has a feature
to automatically activate the test every time the
program is started. This is a good feature but it will
cause the program to load slower depending on the speed
of your CPU. See ch 2, sect 2.8.I.m.
NOTE: If you've recovered backup(s), edited data, or deleted
a record, it's a good idea to run the validity tests.
Data from the memory (see glossary) file will (probably)
NOT agree with the records but this is NOT a problem as
it will be fixed when you run the file test routine.
PAGE 68
2.8.D BACK DATA TO A BACKUP DRIVE: (MISC, option #4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The configuration program (MISC option # 9), has a feature
(option #6) which allows you to select a drive to be used for
your backups.
Although generally a floppy drive should be selected, you may
designate any drive you desire. I recommend using a floppy
drive - OR - a drive with removable media (tape drive ???).
The backup option will transfer the memory (PMMEMORY.MEM) and
the five data files (xxxxxxxx.DBF) to the backup drive you
designated in the configuration routine. Before creating a
backup be SURE the data you will transfer is OK. ie: Run a
file test (MISC option #3) on the data. (See section 2.8.C)
Insert the backup disk into the indicated drive and then press
enter. As with all functions, you will have the chance to
confirm your choice.
The function will test to see if the drive door is closed and
if there is sufficient space available on the diskette to hold
ALL the data files.
NOTE: The backup feature will NOT split files or allow for
changing disks. ie: There must be enough room for ALL
the files to transfer.
WARNING: Check to be SURE you do NOT have a write protect tab
on the floppy diskette. If you do, you will get the
famous DOS "abort, retry, fail" problem message.
You may be able to remove the write protect and
continue using "retry", however, testing has shown
that this is NOT assured 100% of the time. The
results are UNPREDICTABLE !!!!!!!!!
The program will overwrite the previous backups on the disk
with the current files.
SUGGESTION: I recommend you maintain at least two sets of
backups and rotate them each time you backup to a
floppy disk. If you transfer bad data to one set you
will still have the previous set from which you may
recover valid data.
NOTE: You may change the designated backup drive any time
from the configuration program.
PAGE 69
2.8.E DATA FROM OTHER YEARS: (MISC, option #5)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTE: This function will only work if you have saved data
from past years as part of the "Clear files for a new
year" option (MISC menu, opt #6).
The ability to restore data from past years is available for
REGISTERED users only. Why ?? If you've been using
Portfolio Manager long enough to accumulate more than the
current years data, I feel you SHOULD be a "REGISTERED USER".
When you execute the "Clear files for a new year" option in
the MISC menu (opt #6), you will be asked if you would like
to preserve the data for the current year BEFORE the files
are cleared for the new year.
Portfolio Manager has the ability to preserve the current
year's data in special files prior to clearing the data for a
new year. These files may be restored by using MISC opt #5
If restored, the data may be used as if it were the current
data. You may produce reports, enter data, etc. When done,
you may retrieve the current data for the active year.
If you have just registered the program and you have data
files from a previous year you may convert the files for use
with the program by using DOS. From DOS do the following:
1. Change to the disk containing the data you want to access.
ie: the past data files. This should be a floppy or a
different dir from the directory containing PM.
2. Enter the following commands: (xx = year)
COPY PMPURCH.DBF 19xxPUR.DBF
COPY PMBROKER.DBF 19xxBKR.DBF
COPY PMDIV.DBF 19xxDIV.DBF
COPY PMDIVOLD.DBF 19xxOLD.DBF
COPY PMSOLD.DBF 19xxSLD.DBF
COPY PMMEMORY.MEM 19xxMEM.MEM
3. Copy the newly created files to the same directory where
you have installed PM.
WARNING: This procedure will NOT work on data files for ANY
version PRIOR to 4.0. If you have the need to
convert earlier (prior to ver 4.0) data files, you
will HAVE TO CONTACT ME. Each case is unique and
therefore I can NOT distribute a pre-written module
for the conversion.
The program can now load the past year data if you find a need
to do so. You MUST still be a "REGISTERED" user for the program
to load the data files even if they exist in the directory.
PAGE 70
2.8.E DATA FROM OTHER YEARS: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SPECIAL NOTE: The wording of MISC, option #5 will change
depending on the status of the past data. If the current
year is active, the option will read "Retrieve data from
past year" and will perform that function. If data from
a past year is active, the option will read "Restore data
for current year". ie: The same option (MISC, opt #5) is
use to retrieve AND restore data from different years.
The menu item changes depending on the circumstance.
2.8.E.a RETRIEVE DATA FROM PAST YEAR:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This module will allow you to retrieve data from past years IF
you elected to save the data when you did the EOY clearing for
the year in question.
Your PM directory will contain 5 data files and one memory
(see glossary) file. Each will start with the year in question
and have the extension ".DBF" (5) or ".MEM" (1).
ex. 1991PUR.DBF 1991MEM.MEM
SUGGESTION: I STRONGLY recommend you create a backup of the
CURRENT data to a FLOPPY DISK BEFORE proceeding with
the function. Use MISC, opt #4 to create the backup.
The retrieval function operates as follows:
1. You'll have the option to create backup data files with
the ".HLD" extension (same as during the program start).
See ch 2, section 2.0.D.
2. You will be asked to enter the desired year (ie. 1991).
The function will verify that the files are in the
directory before continuing.
3. The requested year will be loaded into active data work
files IF data files for the requested year are available.
4. A file called "pastyear.mem" is created to tell the
program the data is NOT for the current year. This file
will block certain backup functions to prevent you from
overwriting current data contained in the ".HLD" files.
You may now use the data AS IF it were the data for the
current year. You may change data, generate reports, or
anything else the program normally does.
PAGE 71
2.8.E.b RESTORE DATA FOR CURRENT YEAR:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
When you have completed your work with the past year, you MUST
select the PAST YEAR option (MISC opt #5) again to retrieve
the current year's data.
If you made changes you want to PRESERVE, use MISC option #4
to create a backup (to a floppy disk) of the changes. I
suggest you copy the changes to the disk where you keep the
data for that year. Any changes will also be reflected in the
data files for the selected year that are stored in your PM
directory -IF- you choose the save option during the recovery
process for the current year.
WARNING: DO NOT COPY DATA CHANGES TO THE DISK WHERE YOU'VE
BACKED THE CURRENT DATA. YOU MAY OVERWRITE IT.
ALWAYS BE AWARE OF WHICH FILES BELONG ON WHICH DISKS.
NOTE: You can NOT go from one past year to another. You MUST
FIRST restore the current year. You may then use the
function as before to retrieve another year.
SPECIAL NOTE: If you encounter a situation where the program
is telling you the data is NOT current (ie. past data
active), BUT you're SURE you have CURRENT data loaded,
do the following.
1. Exit the program to DOS
2. Change to the PM directory
3. Erase PASTYEAR.MEM. PM looks for the existence of
this file to determine if the data is from the past.
PAGE 72
2.8.F CLEAR FILES FOR A NEW YEAR: (MISC, option #6)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The year end clearing is straight forward, but you MUST take
the following into consideration before using the procedure.
When used, the function will clear all sales and broker
records. All the income records from the previous year will
be transferred to an income history file (PMDIVOLD.DBF). All
reference to investments that were sold during the previous
year will be removed.
To use the feature, select option #5 from the MISC menu and
press Enter (return). You'll be asked to confirm the selection
twice due to the importance of using this feature with care.
WARNING: Do NOT post any information for a New year until
AFTER you've cleared the previous year. If you've
entered data for the new year, you MUST re-enter the
data AFTER you have run the EOY clearing function.
WARNING: Do NOT use EOY function UNTIL you've posted ALL
transactions for the previous year and you have
produced ALL the reports you need or desire. Do NOT
continue the function if you have not made a backup
to a floppy disk of the data files.
NOTE: I STRONGLY recommend you wait until you've received ALL
your 1099's for the past year and compared them to your
records. If there's a difference you may want to change
your data to conform to the 1099's.
==============================================
The following is available to "REGISTERED" users ONLY. The
module is offered as an incentive to register. Why you ask !!!
I feel if you've used the program long enough to warrant saving
data over the course of several years, you should register.
Portfolio Manager has the ability to preserve the current
year's data in special files PRIOR to clearing the data for a
new year. These files may be restored by using MISC opt # 5.
If restored, the data may be used as if it were the current
data. You may produce reports, enter data, etc. When done,
you may retrieve the current data for the active year.
If you have just registered the program and you have data
files from a previous year you may convert the files for use
with the program by using DOS. From DOS do the following:
1. Change to the disk containing the data you want to access.
ie. the past data files. This should be a floppy or a
different dir from the directory containing PM.
PAGE 73
2.8.F CLEAR FILES FOR A NEW YEAR: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2. Enter the following commands: (xx = year)
COPY PMPURCH.DBF 19xxPUR.DBF
COPY PMBROKER.DBF 19xxBKR.DBF
COPY PMDIV.DBF 19xxDIV.DBF
COPY PMDIVOLD.DBF 19xxOLD.DBF
COPY PMSOLD.DBF 19xxSLD.DBF
COPY PMMEMORY.MEM 19xxMEM.MEM
3. Copy the newly created files to the same directory where
you have installed PM.
WARNING: This procedure will NOT work on data files for ANY
version PRIOR to 4.0. If you have the need to
convert earlier (prior to ver 4.0) data files, you
will HAVE TO CONTACT ME. Each case is unique and
therefore I can NOT distribute a pre-written module
for the conversion.
The program can now load the past year data if you find a need
to do so. You MUST still be a REGISTERED user for the program
to load the data files even if they exist in the directory.
2.8.G RECOVER BACK-UPS: (MISC, option #7)
~~~~~~~~~~~~~~~~~~~~~~~~
MISC, option #4 will allow you to create a backup of your data
files to a disk drive designated by you in the configuration
program; usually a floppy disk drive. See ch 2, sect 2.8.D.
This feature will allow the recovery of the backup data in
several different ways.
NOTE: Generally you should recover backup data ONLY when all
else fails. If you can resolve the problem with file
test, edit, or delete you will probably be better off.
I shall assume you want to recover data because there is a
problem with the active data. If the problem is because you
JUST made a mistake with several entries, then certainly
backup recovery is the correct decision. If, however, you are
initiating the recovery because you suspect a data problem,
you should be sure in your own mind that the backups do not
contain the same or worse problems.
SUGGESTION: Before recovering data from your regular backup
disk, use a different disk to make a temporary backup
of the current data. If there is a problem with your
regular backup files, at least you will still be able
to go back to square one.
PAGE 74
2.8.G.a FROM B/U MADE ON START-UP:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you answered "Y" to the backup question on the opening
screen, you'll have created six data files with the extension
".HLD" in the same directory from which you're running PM.
This option will replace the regular data files with the data
in the ".HLD" files.
The hold (".HLD") files are as follows:
PMPURCH.DBF = PMPURCH.HLD
PMBROKER.DBF = PMBROKER.HLD
PMDIV.DBF = PMDIV.HLD
PMSOLD.DBF = PMSOLD.HLD
PMDIVOLD.DBF = PMDIVOLD.HLD
PMMEMORY.MEM = PMMEMORY.HLD
CAUTION: If you backed your data during the program start and
then discovered the data is corrupt, your ".HLD"
files will contain the same problem.
NOTE: Option #4 in the EXIT menu will perform EXACTLY the
same function as this option. See Ch 2, sect 2.1.D.
2.8.G.b FROM YOUR B/U DATA DISK:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This option will transfer ALL the files from your backup data
disk and replace the active data files in the PM directory
with these B/U files.
If you use a rotating backup system, be sure you're using the
latest and/or safest data for your replacement data. This
routine will replace ALL data files with the backup data.
2.8.G.c SELECT ONE FILE FROM B/U:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you know which file was damaged or has bad data, this
option will allow you to replace a single selected file.
Selecting this option will present a list of all the data
files along with a brief description of the file. Use the
arrow keys or point and click with the mouse to select the
desired file from the backup disk.
Consider when choosing this option that some files interrelate
with other files when compiling data or reports.
If you're not sure, its best to replace ALL the files. This
option is mostly for catastrophic failure of data.
PAGE 75
2.8.H ADD/DELETE/RENAME AN ACCOUNT: (MISC, option #8)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This feature allows you to make certain changes to the account
names you've assigned to maintain a record keeping separation
of your investment portfolio.
You may add or create new names, change existing names, delete
an account or move investments from one account to another.
This feature should be used with a bit of caution !!!!!!
An explanation of how the program searches for report data may
give you some thoughts on how to use the feature and where the
problem might be if data APPEARS to be lost after you've used
this option.
ABOUT THE ACCOUNT NAMES: (how the program searches for data)
~~~~~~~~~~~~~~~~~~~~~~~~
The long name you assigned is ONLY used to make the account
more readable in the report headings, etc. and doesn't really
matter for the following discussion. In other words - the
long name of your account is for YOUR use, NOT the program's.
The short name (2 or 3 letter) is used as an important key in
locating securities when they are searched for as part of an
account group.
The short name YOU assigned (or, in the case of a retirement
account, was assigned by the program) is stored in two
locations. One is in the memory variable file ("pmmemory.mem")
and the other is as a part of the record for each investment.
This applies even if you use only ONE account.
Any time data is requested (usually for reports) and the data
is to be grouped by accounts, the program will search for the
data based on the short account name you've assigned.
First the program will look in the memory file for the name
and use the SHORT NAME it finds in the memory file to search
the data files (".DBF") for the requested account.
NOTE: Here is where a problem can arise. If the short name
has been changed in the memory file, PMMEMORY.MEM, but
NOT in the data files, the program will NOT find the
data for the requested account although the data is
still in the records. The file testing, however, will
find AND correct this problem.
WARNING: If you attempt to change the name through the
configuration program (MISC opt #9, sub #3), the
situation described above WILL probably occur, hence
the warning if you select the option from configure
AFTER the initial use of the configuration program.
ie: After you initially assign your account names use
option #8 in the MISC menu to protect against any
conflict in account names. This option will test for
the account names for validity.
PAGE 76
2.8.H.a CREATE A NEW ACCOUNT: (MISC opt #8, sub #1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To CREATE a new account, enter the new long and short names.
If the account will be a retirement type account (IRA, 401K,
etc.), the short name will be assigned automatically if the
account is created in the configuration program.
If the new account is created in the MISC program you will see
a message window on the screen on how to assign the short name
in this type of account. (the message reads)
If the new account is to be an
IRA, 401K, etc. type acct, the
short name MUST be in the form
IRx, where x is the next sequ-
encial number of the number of
retirement accounts you have.
ie. IR1, IR2, IR3, etc.
In a retirement type account the short name is used to key
several reports for tax free status. The program will test
the first two letters of the name to determine if the account
should be treated as a retirement account.
2.8.H.b DELETE EXISTING ACCOUNT: (MISC opt #8, sub #2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To DELETE an account, the account MUST be EMPTY.
The program will check all the data files before deleting. If
ANY records are found in the account you'll be notified and the
program will NOT allow you to delete it.
The best time to delete an account is immediately after the
"YEAR END" processing or after you transfer the records from
one account to another (see below).
If you created an account you didn't need, DELETE will remove
it from the records.
2.8.H.c RENAME EXISTING ACCOUNT: (MISC opt #8, sub #3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To RENAME an account select the name to be changed from the
list of existing names and then enter the new name.
This is one of the key areas of protection referred to in the
warning above. If changes are made with the configuration
program rather than with MISC option #8 a problem could occur.
When you rename an account with MISC opt #8, after confirming
your choice, the program will search ALL the data files and
change the name at each occurrence.
PAGE 77
2.8.H.d TRANSFER AN ACCOUNT: (MISC opt #8, sub #4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Use the TRANSFER option to move ALL records from one EXISTING
account to another EXISTING account.
SUGGESTION: If you need to move one or two securities from
one account to another, I suggest you use the edit
option, MISC opt #1. Be SURE you change all the
records for the designated investment.
A menu of the existing accounts will be shown in a window on
the left. You will be asked to select which account you want
to transfer FROM. After you select the FROM account, the
function will ask you to select the destination (TO) account.
A window on the right will display the FROM and TO accounts
and ask you to confirm the transfer.
Use this function with CAUTION: Once completed, the records
in the sending account WILL be mixed with records in receiving
account. The process can NOT be reversed (except with your
back-ups).
NOTE: The account name of sending acct will NOT be removed,
but the account will be empty. NOW would be a good
time to use the DELETE an account function !!
SUGGESTION: I strongly suggest making a BACKUP of your files
before proceeding. As soon as you complete the changes,
go to the report menu and generate a couple of reports
to the screen. This is where a problem will be evident
if one was created.
PAGE 78
2.8.I CONFIGURE PORTFOLIO MANAGER: (MISC option #9)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The configuration program may be used any time you wish to
change the defaults or the way you use the features of the
program.
NOTICE: The first time the program is started by a NEW user
* OR * a "REGISTERED" user after receiving a new update,
the configuration menu should be activated automatically.
If this is not the case you may call the configuration
menu through MISC opt #9.
The automatic call feature was designed to make it
easier for a NEW user to get started. If you're a
previously registered user, the automatic call of the
configuration program is to activate new features in
the updated version.
You may change ANY or ALL of the user set options to meet
your requirements. You may experiment with different color
combinations or block the printing of empty reports. If
Congress changes the capital gain holding period, this is
where the new period should be entered. You can reset the
automatic numlock feature or change the name you want to
appear on reports. Automatic data testing may be activated
from the configuration menu.
You may exit any individual menu item in the configuration
menu with the ESC key. If you use the ESC key to exit the
main configuration program, and IF you've changed any user
set options, you'll be asked if you want to save the changes.
When you select option G (Exit...) you'll be shown all your
choices and asked to confirm any changes you may have made.
If you answer "N" to the "Save the changes" question, you'll
be shown all the current settings and asked if you want to
EDIT the changes. A "Y" response will return you to the
configuration menu while a "N" response will cause the program
to retain the original user set options and return to the main
program menu.
If you've made any changes, exiting the configuration module
will cause Portfolio Manager to be re-started. This is to
allow the changes you made become effective.
NOTE: If you change your mind on an option, just re-select
the item from the menu and enter your preference.
SPECIAL NOTE: Each item, when selected, will display the
applicable instructions for the selected item. If you
want to explore an item, just select it. You may use
ESC or accept the default response to return to the
configuration menu.
PAGE 79
2.8.I CONFIGURE PORTFOLIO MANAGER: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTE: The automatic call feature WILL remain set UNTIL you
CHANGE AT LEAST ONE ITEM in the configuration menu AND
SAVE the change. I assume all user will change the
name (unless your name really is "I.C. Wealth").
Registered users upgrading from an earlier version
SHOULD use the color selection option as it will reset
the version number on the opening screen. You may re-
select the same color to meet this requirement.
THE FOLLOWING IS AN EXPLANATION OF THE CONFIGURATION MENU ITEMS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2.8.I.a STEP THRU 2 TO E BELOW: (MISC opt #9, sub #1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you're a new user, you may find it easier to use menu
option #1 "Step thru 2 to E below" (all the options). If you
select option #1, the configuration program will execute each
menu option in sequence with the exception of the last item
(Clear all data files).
As each user defined option is called, the instructions for
that feature will appear on the screen. In each case a
default response will be indicated. The default response is
highlighted. If you press enter or click with the mouse, the
program will accept the indicated default response.
2.8.I.b COLOR SELECTION MENU: (MISC opt #9, sub #2)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The program may be use with ANY monitor. If you have a color
monitor, you may choose from eight color patterns. A black &
white or monochrome monitor will allow you two options, black
on white OR white on black (I prefer white on black).
After you select a color from the color menu, a demonstration
screen will be activated to ask if the colors are OK.
A "NO" response will return you to the color menu. With some
computers, it has been reported that the colors are reversed
upon a return to the menu. If this occurs, select another
color and you'll find that the problem has been corrected.
TIP: If you're using a mouse to select a color combination,
put the cursor on the desired option in the COLOR MENU,
NOT on the small color sample window on the screen.
NOTE: All users should use this option EVEN if you want to
maintain the existing colors. The reason is that the
feature will reset the opening screen presentation. If
you're newly registered, the registration solicitation
will be removed. If you were already registered, the
version number on the opening screen will be updated.
PAGE 80
2.8.I.c DEFINED YOUR ACCOUNTS: (MISC opt #9, sub #3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This option is for NEW USERS to establish the accounts you may
want to use to separate your portfolio into logical sub-
divisions.
Do not confuse the concept of separate accounts with separate
portfolios. The idea is to take your regular investment
portfolio and separate them into logical divisions for record
keeping purposes ONLY. This does NOT suggest the necessity of
separate brokers, funds, etc.
I am also NOT suggested that investments in mutual funds be
separated by the mutual fund "families" (unless it happens to
coincide with some other division you want to make).
ex. You own several funds in the Franklin group and several
funds in the Oppenheimer group. I am NOT implying that
you should put each group in a separate account.
NOTE: Do NOT confuse separate accounts with separate portfolios.
Portfolio Manager has the ability to manage an unlimited number
of investment portfolios for those having the need (brokers,
advisors, counselors, etc.). This module sold separately and
is available to REGISTERED USERS ONLY for an additional $50.00.
The MPM module is NOT required for the normal use of the program
by individuals. It may be a useful feature for those who
maintain portfolios for others. See chapter 2, section 2.1.G.
If you've been using the program and have investments entered
into some of the accounts you've already established, I suggest
you do NOT use this function. When you first select the option,
a warning window will appear if you've already established accts.
WARNING: To change or delete YOUR established accounts, I
STRONGLY suggest using MISC opt #8. It WILL protect
against problems in locating YOUR investments in the
account records. See Ch 2, sect 2.8.H.b & 2.8.H.c
Portfolio Manager can handle from 1 to 5 accounts in a single
portfolio. It was designed to track investments designated
for a SPECIAL purpose from within your portfolio.
You may want to separate an IRA from your other investments.
Investments for the education of your children may deserve a
separate account. You may want to maintain a separate records
for your spouse (a separate IRA ??). How about an account for
investments thru or for your business or employer.
When you first select the option, you'll be asked how many
accounts you wish to establish. You may enter a number from
1 to 5. You MUST have at least 1 account.
PAGE 81
2.8.I.c DEFINED YOUR ACCOUNTS: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
After you respond to the number of accounts you would like to
establish, you will be asked if ANY of the accounts will be a
retirement type account such as an IRA, 401K, etc.
If you respond "Y"es to the question, the next step, which
will ask you to name the accounts, will also ask if the
account will be a tax deferred account. If the account is to
be a retirement account, answer "Y"es.
NOTE: Each account you establish will have two names, a short
name (3 letters max) and a long name (14 ltrs max).
See Ch 2, sect 2.8.H (Add/Delete/Rename an acct) for a
explanation of account names and how they are used.
If the account is a retirement type, the short name will be
assigned by the program. If it isn't a retirement type, you'll
be asked to supply a short name (3 letter max). The next step
will ask you for the long (14 letter) name for your account.
WARNING: Each account MUST have a name EVEN IF YOU HAVE ONLY
ONE ACCOUNT.
Default names for both names (long and short) are shown on the
screen. If you want to accept the default name, press enter.
The program will repeat the above steps to name an account for
the number of accounts you indicated you wished to establish
when asked how many accounts.
2.8.I.d ENTER/CHANGE USER NAME: (MISC opt #9, sub #4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter a name as you would like it to appear in the main menu
and on reports the program will generate. Limit is 25 chars.
ex. I. C. Wealth
ex. John and Mary Smith
2.8.I.e SET A DEFAULT RESPONSE: (MISC opt #9, sub #5)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The program uses default answers throughout the package.
This is shown by the highlighted option when a response is
required. The default is selected by pressing "ENTER"
(return) or by entering 1st letter of the option. If you're
using a mouse, you may point and click on the default.
One of the default options should be set by you, the user.
When you enter income to the records through the INCOME option
in the main menu, you'll be asked if the income is to be re-
invested. This is a Yes/No question and you should set the
default response (ie, Yes or No) with this option.
You, of course, must determine which response is most applicable.
PAGE 82
2.8.I.f ASSIGN A BACKUP DRIVE: (MISC opt #9, sub #6)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The program has a feature which will allow you to backup (or
recover) the data files to (from) ANOTHER disk drive.
If you done any reading in this manual, you'll know by now
that I'm a strong advocate of frequent backups. In this
procedure you may select the drive which will be used for the
BACKUP files. (I suggest using a FLOPPY disk drive).
See Chapter 2, sections 2.8.D and 2.8.G
2.8.I.g NUMLOCK ON/OFF- NUMERIC: (MISC opt #9, sub #7)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This feature is MOSTLY for those who do NOT have a 101 key
keyboard. This would apply to some older keyboards and to
most portable computers.
Portfolio Manager uses numeric and arrow input extensively.
This feature was designed to switch between numbers and arrows
automatically on the numeric keypad when appropriate.
ie. switch NUMLOCK on & off automatically
2.8.I.h SET MOUSE SENSITIVITY: (MISC opt #9, sub #8)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you use a mouse, you may use this feature to set the
sensitivity of your mouse controller to any speed from very
slow to very fast.
A window on the screen will display numbers from 1 to 10.
1 is the slowest setting while 10 is the fastest. The default
number will be highlighted.
Feel free to experiment with the different settings. Use the
arrow keys (or your mouse) to select the desired setting.
2.8.I.i PRINTER SELECTION: (MISC opt #9, sub #9)
~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is a new feature with this release of Portfolio Manager.
Laser printers do not allow the same number of lines per page
as do standard (non laser) printers. As a result the
pagination of some reports may not be correct if this feature
is not set to ON.
If you're using a laser printer, respond "Y"es to the question
that asks if you are using a laser printer.
If you use a laser printer and set the feature at NO, you'll
find the reports may eject blank pages or continue the report
on the next page without proper headings.
TIP: If you're having a problem with the pagination of your
reports, and you aren't using a laser printer you might
try setting this feature to "ON" (YES) anyway to see if
that will correct the problem.
PAGE 83
2.8.I.j DEFINE REPORT CONTENTS: (MISC opt #9, sub #A)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This feature will determine if a report should be displayed or
printed depending on the contents of the report.
You may set the option to show ONLY those reports that have
data (information) to display/print.
The feature will ask if you want to display/print a report
even if it will be empty. If you respond "Y"es, a requested
report will be shown even if it does not contain any useful
information.
For example:
If you have entered a number of investments, but haven't sold
any of them yet - if you answer "NO", the "SOLD" report will
NOT display or print.
In other words; do NOT produce a report if there's nothing to
report.
2.8.I.k SET CAP GAINS PERIOD: (MISC opt #9, sub #B)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Periodically Congress, in its infinite wisdom, changes the
holding period for LONG TERM capital gains.
This feature allows you to set the current period. Be sure to
enter the time period in DAYS, not months or years.
The holding period you enter will be used primarily to
separate the sales report and tax reporting forms into long
and short term gains/losses.
Like ALL configuration features, this variable may always be
changed by selecting CONFIGURE from the MISC menu.
2.8.I.l SET THE BROWSE COMMAND: (MISC opt #9, sub #C)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FOXPRO'S(tm) BROWSE COMMAND:
If you do not already know what "BROWSE" is, you should NOT
activate this feature.
The "BROWSE" command will allow direct access to the raw data
files. This means that, when chosen, the selected database
will appear on the screen as raw data. There will be no
protection for any changes you may make. The results of any
changes are unpredictable. It could range from loosing
records (don't appear where they should) to making the program
crash due to a conflict in data types.
PAGE 84
2.8.I.l SET THE BROWSE COMMAND: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you elect to activate the BROWSE command, be sure you have
a backup before you use it and test all the reports thoroughly
before continuing. If activated, the browse command will be
option #4 under MISC menu, option #1 (edit).
Unless you are comfortable using the BROWSE command in a dBASE
or FOXPRO environment, answer "N" when asked if you want to
activate it.
WARNING: If the browse feature is used improperly, it MAY
render your data files UNUSABLE.
2.8.I.m AUTOMATIC DATA TESTING: (MISC opt #9, sub #D)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The program has a module to test the data files. It may be
set to run the test automatically. When the tests are run
will depend on which option you chose for the activation of the
feature. The four available options are:
1 - Run tests on program start ** AND ** on exit
2 - Activate auto tests on program START only
3 - Activate auto tests on program EXIT only
4 - Do NOT activate ANY automatic file tests
When the test is activated, either through one of the automatic
options listed above - OR - selection from the MISC menu,
option #3, it will take 3 to 20 seconds to complete depending
on the CPU (Central Processor Unit - 8088, 286, 386, 486, etc.)
in your computer.
SUGGESTION: I recommend you activate the automatic test on
the program start. The tests are executed BEFORE you
are asked if you want to backup the data files to hold
files (".HLD") on the opening screen. If there is a
residual problem from the last time you used PM, the
problem will be reported prior to contaminating the
backup files. This will allow you to trace the problem
or recover the backups.
I recommend you review Chapter 2, section 2.8.C for a complete
explanation on file testing and Ch 2, section 2.8.G for infor-
mation on recovering backup files.
PAGE 85
2.8.I.n SET EXTRA HELP SCREENS: (MISC opt #9, sub #E)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I feel most of the program is intuitive, however, there are
some areas that does require some additional information or an
explanation.
At these features a help screen or a suggestion to see a help
screen (use F1) may appear. As you become familiar with the
program, you may find these screens annoying.
This feature will allow you to activate or deactivate the
automatic pop-up help feature. If you respond NO to the "Allow
auto help screens & suggestions to appear", these help tips
and suggestions will NOT appear.
SUGGESTION: Leave the auto help feature active until you are
familiar with the program. Most of the tips and help
screens are in the seldom used areas of the program.
Normal help will still be available with the F1 key REGARDLESS
of the setting of this option.
2.8.I.o CLEAR ALL DATA FILES: (MISC opt #9, sub #F)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WARNING: Use of this option will remove ALL data from the
data files. It will re-set all the memory variables.
The files will appear the same as the first time you
started the program. You will have to re-enter your
name, accounts, color settings, etc.
The option was included to allow you to remove practice
(test) data or start your records again if you're not
satisfied with the initial way you started your records.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| WARNING WARNING WARNING WARNING |
| |
| DO NOT USE THIS OPTION UNLESS YOU WANT TO REMOVE |
| ALL DATA YOU HAVE ENTERED AND RESET ALL VARIABLES |
| TO THE WAY THEY WERE ON THE DISTRIBUTION DISK. |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The "Clear... " feature is useful under certain circumstances.
For instance you may have entered some practice data to get a
feel for the program when you first received it. You may have
started to set up accounts and enter data then decided to do
things differently. Perhaps you entered some investments and
then discovered that you entered then wrong.
As usual, before you use this feature, I suggest you make a
backup of the data files just in case you change your mind.
WARNING: Do NOT confuse "Clear the data files" with "Clear
files for a New Year" (MISC opt #6). The "Clear..."
feature changes only selected files necessary to begin
a new record keeping year.
PAGE 86
2.8.I.o CLEAR ALL DATA FILES: - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Once you clear the data files, you will have to enter all the
basics such as your name, the acct names you wish to use, the
color settings, etc. The data files will be completely empty.
2.8.J CHANGE NAME OF AN INVESTMENT: (MISC, option #A)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This function may be called from either the EDIT sub-menu OR
from the MISC menu, Option A. Either way, the program performs
the identical function. The original name change routine was
in the edit option, but users were having trouble finding it
so I moved it to the MISC menu but saw no reason to delete it
from the edit menu.
Option #3 of the EDIT menu OR MISC opt "A" will assure that the
name is changed properly in all the files.
Several items appear in all the data files. The name of an
investment is one of them. If a company changes its name or
is merged into another company you will want to reflect that
change in the data files. You could go through all the files
and change the name manually at each occurrence, but that
could be tedious if you've had the investment for a while and
have created multiple entries for it.
This routine was designed to find each occurrence the old name
and replace it with the new. It will go through all the data
files (5) and update the indexes as well.
If you made a mistake, do the routine again and make the
correction. ie. You need only change the name again (back to
the original ???).
NOTE: If you've entered a security name but are having a
problem distinguishing it from other investments with a
similar name, you might consider using this routine to
change the name to a more unique or meaningful name for
your own use.
PAGE 87
2.9 B O N U S M E N U
~~~~~~~~~~~~~~~~~~~~
G E N E R A L I N F O R M A T I O N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The bonus programs are offered as an incentive to register.
The unregistered version does not include the bonus programs,
however, the absence of the bonus modules does NOT limit or
restrict the program in the performance of its primary
functions.
In option # 3 (financial calculations) and option # 4 (loan
computations), after you make the initial entries for the
desired function, you may redo the calculation using YOUR
entries as the default variables in the next calculation. You
may then vary one (or more) of the variables to determine the
effect on the overall situation.
For example:
You borrow $10,000 at 10% for 10 years. How much is the
monthly payment ?? After the program calculates the result
($132.15), it will ask if you want to redo the problem and
change one (or more) of the variables. If you respond "Y"es,
the program will accept the original numbers as the starting
default and you only have to change the desired variable.
Maybe check the payment if it were a 5 year loan ($212.47).
2.9.A CALCULATOR PROGRAM: (BONUS, option # 1)
~~~~~~~~~~~~~~~~~~~~~~~~~~
The CALCULATOR functions as a normal basic calculator. It may
be ACTIVATED from within ANY Portfolio Manager operation.
The calculator may be activated by selecting option # 1 from
the BONUS menu - OR - pressing the "F2" key on the function
key pad.
If the calculator is called while the program is awaiting
numeric input, the results of the calculators will be returned
to the calling program. You will have the option to accept or
change the number in the input field.
For example:
You're entering a dividend and the program is waiting for you
to enter the amount of the dividend. Your dividend statement
contains three entries for the dividend (reg div, long term
capital gain, and a short term capital gain). To combine them
for the "Amount of dividend" entry, use the "F2" key to
activate the calculator and add the three amounts. When you
exit the calculator, you will be returned to the same place in
the program where you were when you pressed the "F2" key. The
result of the calculator computation will appear in the input
window. If you want to accept the number, press Enter (return).
PAGE 88
2.9.B CALENDAR PROGRAM: (BONUS, option # 2)
~~~~~~~~~~~~~~~~~~~~~~~~
The CALENDAR displays a month at a time. You may project
forward or backward in months or years.
I find the program helpful in checking on the expiration dates
of options and/or commodities. You may want to determine if
an expected payment date will fall on a weekend this month.
This program won't revolutionize the computer world, but, if
you need a date/day in the past or future, it will save you
from searching paper calendars.
2.9.C FINANCIAL CALCULATIONS: (BONUS, option # 3)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This module is a collection of fourteen assorted financial
calculations that MAY aid you in making investment decisions.
The function will calculate the following.
Present value of a bond
Yield to maturity of a bond
Net present value of investment cash flows
Interest earned between two dates
Internal rate of return on cash flow
Future value of one time investment
Future value of reg deposit (annuity)
Reg dep req'd for desired future value
Withdrawal for future value of $0.00
Single inv now for definite future value
Nominal interest earned on investment
Minimum investment required for income
Net cost of discounted notes/paper
Present value of a future amount
2.9.D LOAN COMPUTATIONS: (BONUS, option # 4)
~~~~~~~~~~~~~~~~~~~~~~~~~
This module is very helpful in evaluating loans. If you're
considering borrowing money, you might want to use this module
to compare all the possible variables such as term, interest
rate, and repayment options.
The following loan computations are available:
Amount of regular loan payment
Find the principal amount on a loan
Principal on loan after 'x' paym'ts
Interest rate paid on a loan
Time required to repay a loan
Amount of balloon payment on a loan
Amortization schedule (print/screen)
There are four basic parts to a loan computation (principal,
rate, term, and payment amount). In most of the above, if you
provide 3 variables, the fourth will be calculated for you.
You may then vary one (or more) of the 3 variables using your
input as the starting defaults to determine the effect on the
computations. See the example under 2.9 (general information).
PAGE 89
CHAPTER 3: - THE OTHER STUFF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3.A L E G A L C O N S I D E R A T I O N S
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Definitions:
PM and Portfolio Manager shall be used interchangeably
SSI and Shane Software shall be used interchangeably
3.A.a DISCLAIMER - AGREEMENT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Users of the Portfolio Manager must accept this disclaimer of
warranty: "Portfolio Manager is supplied as is. The author
disclaims all warranties, expressed or implied, including,
without limitation, the warranties of merchantability and of
fitness for any purpose. The author assumes no liability for
damages, direct or consequential, which may result from the
use of Portfolio Manager."
Portfolio Manager is a copyrighted program protected by both
U.S. and international copyright law. If you obtained the
program from a shareware disk vendor, an on-line computer
service or bulletin board, a friend or colleague, or other
similar sources, you have an UNREGISTERED version of PM.
A REGISTERED version of Portfolio Manager is a copy which was
purchased directly from Shane Software International OR an
authorized representative of SSI. It is evidenced by a disk
with a label bearing a serial number and the word "registered".
3.A.b LIMITED WARRANTY:
~~~~~~~~~~~~~~~~~~~~~~~~
Shane Software International warrants to owner of a registered
copy of Portfolio Manager that the software will operate in
accordance with the description given in the documentation,
and that the disk(s) will be free of physical defects which
might interfere with normal use. For a period of 90 days from
the date of your purchase of Portfolio Manager, SSI will,
subject to the restrictions above and below, repair or
replace any defective item, or refund the purchase price of
any diskette and/or any other parts or components of Portfolio
Manager found to be defective, IF such defect is the fault of
SSI and not the result of misuse or abuse. Such a refund,
repair, or replacement shall be your sole remedy for any
defects, program error(s), or documentation error(s). In no
event shall Shane Software International be responsible for
any other costs or damages whatsoever due to errors in usage
or your failure to read, understand, or follow instructions in
the documentation.
SHANE SOFTWARE INTERNATIONAL MAKES NO OTHER WARRANTIES, EXPRESSED
OR IMPLIED, INCLUDING WITHOUT LIMITATION THE WARRANTIES OF
MERCHANTABILITY AND OF FITNESS FOR A PARTICULAR PURPOSE. SHANE
SOFTWARE INTERNATIONAL WARRANTY IS EXPRESSLY LIMITED TO THE COST
OF REPLACEMENT OF ANY DEFECTIVE DISK(S).
PAGE 90
3.B L I C E N S E A G R E E M E N T
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Copyright laws apply to both Shareware and commercial software,
and the copyright holder retains all rights, with a few
specific exceptions as stated below. Shareware authors are
accomplished programmers, just like commercial authors, and
the programs are of comparable quality. (In both cases, there
are good programs and bad ones!) The main difference is in
the method of distribution. The author specifically grants
the right to copy and distribute the software, either to all
and sundry or to a specific group.
Shareware is a distribution method, not a type of software.
You should find software that suits your needs and pocketbook,
whether it's commercial or Shareware. The Shareware system
makes fitting your needs easier, because you can try before
you buy. And, because the overhead is low, prices are low.
It's only through your honest support that this and other
shareware programs can be offered at low costs.
PM, Version 4.3 and above, will usually be distributed on
three 5.25 diskettes. Disk 2 and disk 3 are identical for the
registered and evaluation copies of PM. The label on disk 1
provides the distinction between a registered copy and the
evaluation copy.
Unregistered "evaluation" copies of PM are distributed to
allow you to try the program before you pay for it. The
unregistered shareware version of the program may be used free
of charge for an evaluation period of up to 30 days. If you
decide you like PM and want to continue using it beyond the 30
day trial period, you should purchase a registered copy from
SSI or an authorized representative. Continued use of the
program beyond the trial period will not result in any
"hostile" action or limit program or data access. Like most
shareware programs, it is up to the individual user to
determine if the program provides enough value to warrant
continued use and hence a formal registration.
A registered copy of PM will be registered in the name of the
person who purchased it. Your registered copy of PM may be
used on up to two separate computers, provided you are the
only person who uses it on both machines. This allows you to
install PM on a home computer and on a PC at work. The
REGISTERED copy of PM is not copy protected, and you may make
as many backup copies as you deem necessary as long as they
are not distributed or resold in any form.
PAGE 91
3.B LICENSE AGREEMENT - (continued)
3.B.a DISTRIBUTION RESTRICTIONS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You may copy and distribute an UNREGISTERED shareware version
of PM only. The distribution disks may be passed to other
users provided you do NOT release the registration disk to ANY
other person. Regardless of the type media on which the
program was distributed (see 2 above), you may not give,
transfer, or otherwise allow another person to have, copy,
use, or obtain in any other way a copy of a disk with a label
bearing a serial number and/or the word "registered".
If you distribute the shareware "evaluation" copy of PM, the
program must be distributed in its entirety, including all
modules and documentation. Due to the size of Portfolio
Manager, the evaluation copy MUST be distributed on it's own
media and may NOT be combined with any other software without
the express written consent of the author. An exception to
the above is the addition of ".DOC" file(s) by a vendor or
distributor to explain or expand on information about the
program or it's distribution. The price charged for an
evaluation copy of PM should not exceed an amount which covers
the reasonable costs of distribution.
You are encouraged to pass a copy of Portfolio Manager along
to your friends for evaluation. Please encourage them to
register their copy if they find the program useful. All
registered users will receive a copy of the latest version of
the Portfolio Manager system plus the Bonus programs. See
chapter 1, section D.
Commercial users of Portfolio Manager must register and pay
for their copies of Portfolio Manager within 30 days of first
use or their license is withdrawn. Site-License arrangements
may be made by contacting Shane Software Int'l.
3.B.b VENDOR DISTRIBUTION AUTHORIZATION
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Authorization to distribute Portfolio Manager and charge a
reasonable distribution fee is granted, however, this fee may
not exceed the reasonable cost of per disk distribution
(suggest $6.00 or less per disk). If you're distributing
Portfolio Manager as a commercial vendor, PLEASE notify Shane
Software Int'l so you can be kept up-to-date with the latest
version of Portfolio Manager.
--==> NOTE <==--
FOR THE FULL REGISTRATION AND WARRANTY INFORMATION SEE THE
FILE PM-LICEN.DOC. TO PRINT THIS FILE SELECT OPTION # 4 IN
PM-PRINT.COM or TYPE "COPY PM-INSTL.DOC PRN" AT DOS PROMPT
PAGE 92
Portfolio Manager - Order Form
Return to: Steve Hane
Shane Software International
107 17th Court
Sequim, WA 98382
Name __________________________________________________
Address __________________________________________________
__________________________________________________
Diskette size: (Hi capacity disks used if wanted AND needed.)
__ 5.25" 360KB __ 5.25" 1.2MB __ 3.5" 720KB __3.5" 1.44MB
Please tell me which version of PM you're using. Ver # __.__
What was YOUR source of PM __________________________________
CompuServe ID (if applicable): ______________________________
Please include any comments or suggestions for enhancements
on a separate sheet of paper.
Thank you for registering your copy of PM. You'll be notified
of future upgrades. Upgrades will contain fixes and new
features, many of which you simply can't live without.
Quantity Price
Registration Fee ($49.00 each) _____ ______
Sales tax (Washington State only, 7.8% of total) ______
Shipping charges, per copy: ______
N/C US standard, $3.00 Canada, $5.00 others
Total enclosed: ______
Payment method: ___ Check ___ Mastercard ___ Visa
Card # ____________________________ Exp Date: ____/____
Signature______________________________________________
For credit card payment (M/C or VISA), use our TOLL FREE order
number 1-800-742-6303 (1-800 SHANE 03) (ORDERS ONLY PLEASE).
Upon receipt of this paid invoice, a copy of the BONUS programs,
all revisions, and all updates since release will be sent. You
will be notified of future upgrades.
THANK YOU FOR REGISTERING
PS. Even if you do not use this form PLEASE answer the questions
such as version number, program source, type media, etc.
NOTE - If you have NOT printed this manual, you may find it
easier to print the form PM-INVOI (use PM-PRINT.COM)
PAGE 93
3.D I N C A S E O F T R O U B L E
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3.D.a ERROR FILES
~~~~~~~~~~~~~~~~~~
If, during the execution of the program, a technical problem
(bug ????) is encountered an error screen will be activated
with the following message:
The file,"xxxxxxxx.ERR", was created containing the
information I NEED to trace the problem. Please send
me a copy of the error file. I need the ACTUAL file,
NOT a copy of this notice with the file name. You may
send the file(s) on disk or as a printout(s). Without
the actual error file, I can ONLY make an educated guess
NOTE: xxxxxxxx.ERR is a randomly assigned filename for
the error file
This error file will be written to the same directory in which
PM is located. Please do NOT send me a copy of the screen or
just the name of the error file (xxxxxxxx.ERR) as it has NO
value to me in resolving the problem. It is the actual file
that is created that has the information that I will need to
attempt to trace the problem.
If you re-tried the SAME routine several times and the same
error re-occurred, a new error file will be created each time
the error occurs. Each of these error files will have a
DIFFERENT name but will contain the SAME information.
If this is the case, you need only send the file with the
latest time and date stamp. If you're uncertain, by all means,
send all the error files. It doesn't matter whether you send
the error file(s) on a disk or as a print out. Do whichever
is easiest for you.
NOTE: To send all the error files on a diskette enter the
following command from the DOS prompt in the PM directory:
ex. C:\PM>COPY *.ERR A: (assuming diskette is in Drive A:)
If you have ".ERR" files on your disk and you feel the problem
has been resolved to your satisfaction, or you don't feel a
need to send the files to me, you may erase the ".ERR" files.
3.D.b ABNORMAL PROGRAM TERMINATION:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If a program was terminated in ANY way other than the EXIT menu
and the TERMINATION option (opt 1), the next time you start
PM a help screen will activate automatically.
NOTE: See Chapter 2, section 2.1.A for additional information.
PAGE 94
3.D.b ABNORMAL PROGRAM TERMINATION - (continued)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The purpose of the help screen is to advise you that the last
time you used PM, you may have had a problem and you should
run the file tests to determine if any files or data records
were damaged because of the irregular program termination.
To leave the help screen, press the ESC key. The next screen
will ask you if you want to test the files. I suggest you
respond Y(es) to the question. If the file tests report any
problems, you may want to review the data to see if the
problem can be found and resolved via the edit option. If
possible, you may want to use your backup files.
NOTE: See Chapter 2, section 2.8.C (file testing) for more
information on the file tests. File testing may also
be activated anytime you wish using MISC option # 3.
In some cases you'll know why the program was terminated
abnormally the last time it was used. For example, little
Bobbie pulled the plug.
SUGGESTION: Do NOT answer "Y" to "BACKUP DATA" question on the
opening screen UNTIL you check the data to be sure
it is complete and accurate.
PAGE 95
3.D.c TECHNICAL ASSISTANCE:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you've encountered a problem with the program or need
technical assistance please contact:
Steve Hane
Shane Software Int'l
107 17th Court
Sequim, WA 98382
Technical Support line (206) 681-2402
***** N O T I C E *****
PRIOR TO CONTACTING ME FOR ASSISTANCE, PLEASE RUN THE FILE
TESTS AVAILABLE IN THE "MISC" MENU, OPTION # 3. THIS TEST WILL
RESOLVE MANY OF THE PROBLEMS THAT ARE RELATED TO DATA FILES.
Technical assistance is NOT restricted only to registered
users. I feel if there is a problem, I want to know about it
and make every effort to correct it whether it's a programing
bug or confusion over how to do something. If I feel you're
asking questions that should only be answered for a registered
user, I'll say so.
As of the preparation of this manual, Shane Software is not
large enough to support a full time office. If you attempt to
contact me by phone and don't get an answer, PLEASE try again.
I will accept calls at any REASONABLE hour (9am to 9pm Pacific
time) seven days a week. Generally early evening is best.
Perhaps by the time you read this, (and with your support),
I'll have full time coverage.
If the program fails due to a programing OR data error, a
special error screen will be activated (see above). The error
screen will offer you the option to cancel, ignore, retry, or
try the main menu.
Cancel - Terminate the program
Ignore - Return to next programing command line
Retry - Return and retry same program command
Try main menu - Return to the top (main) menu
Of course it's impossible to say which choice is best as it
depends on the circumstances at the time of the failure. The
safest is generally to CANCEL until the problem is resolved.
Do NOT attempt more then one "retry" or "ignore" for an error.
Even if all seems ok after the "retry" or "ignore", PLEASE
check your data closely before proceeding. The best way to
check your data is through the report menu. Generate a report
for the area that is under suspicion. I also recommend
running the file tests from the "MISC" menu, option # 3.
PAGE 96
3.E H I S T O R Y O F P O R T F O L I O M A N A G E R
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---- April 1985 - version 1.0
First release. Released as a .WKS to be used with Lotus 123.
---- June 1985 - version 1.1
Bug fixes. Allowed 0 in shares cell, caused divide by zero
error. Sales report did not separate long/short term sales.
---- June 1987 - version 1.2
Fixed minor reported bugs. Added method to separate IRA
income from regular income.
---- March 1989 - version 2.0
Complete rewrite of PM. Converted to Foxbase+. Used the
Foxbase runtime compiler to release a stand alone product.
---- April 1990 - version 2.1
Changed version number to reflect correction of numerous bugs.
Added file testing, multiple accounts, and IRA separation.
---- October 1990 - version 2.2
Added ability to produce ROI reports
Added expanded and improved yield (est & actual)
---- January 1991 - version 3.0
Complete re-write. Converted to Foxpro to take advantage of
the many new features.
Test if ALL data files exist before doing Getsummary
Moved dimension dbf_file from PROC to START - now permanent
Change year shown in help for "clear for new year"
Re-write Getdate proc to function. Changed getdate in all prgs
If year entered differs from records year, the entry is no
longer blocked - it IS challenged to verify if correct
Dropped warnings about dates that are no longer required
Total gain or loss on sales moved 1 col to right to line up
If data entry for a PARTIAL sale is edited after entering, the
data display numbers are wrong - actual data is correct.
Fixed display. Change - if stock has only ONE record in
purchase record AND a partial sale is made the "select which
shrs to sell" screen is bypassed.
Test amount of DOS memory left before calling DOS ERASE to remove
all WORK (TEMPxxxx.xxx) files. Error occurs if insufficient
On ROI report show time held in years instead of days
Don't allow a name of less than 3 char for a stock name
Improved screen presentation of an account transfer (opt4)
On restart removed ! ERASE TEMP*.*. Added test to see if
TEMP.MEM exists - if not create it
On sale of bond, comm inaccurate. Added ncomm/10 to prg.
Restricted use of "PM" or "TEMP" as name on disk report file
Created capability for reports to be sent to a disk file. "fcnt"
new variable for line counting.
PAGE 97
---- March 1991 - version 3.1
Reference to sample data dropped for users upgrading to V3.1
Clarify language of on screen instructions for some features
Clarified color language. Added block against SAME color
Added section to suggest how to enter data to start records
Record count in heading wrong if "edit more - same stk"- fixed
Changed % G/L to G/L per share in "value report"
Clarified instructions on how to modify "CONFIG.SYS" to 40
Minor language changes to clarify
Clarified procedure on exiting PM after use
Correct typing errors
Purchase report "TOT COST" was wrong due to comm. Corrected.
Blocked duplicate entry of "short" account name
Trim menu selection number from display - created bstring var
Dropped "WRONG VERSION OF PM" message on initial upgrade
Modified printing of amortization schedule. added loan info
---- July 1991 - version 3.2
Added registration screen to exit menu.
ERROR in broker acct review. Changed FOR i=1 to mmACCTNO to DO
WHILE i <= mmACCTNO. Error appeared to be intermittent.
Added "ORDINARY INCOME" column to 1099 report.
(Ckbkramt) added routine NOT to multiply by 10 if interest
payment on bond. Added ESC test while waiting for bkr amt.
"1099" report now extracts IRA income and reports it separately
Intr on bond sale not cleared before "short term" rept - fixed
Sold report extracts IRA info to a separate report added to
the end of the regular report.
Added capability of multiple IRA accounts. Acct name set by
program to allow separation in repts.
(Getname) Display default on a acct name change.
Before getting account names ask if any will be IRA's
If acct is IRA and $0.00 is entered for TF amt, challenge
---- November 1991 - version 3.3
(Ckprton) add col to center screen display for "writing" file
On 1099 repts correct totals at end of the report
Added acctnameS(6) & acctnameL(6) = ' '
Error if ESC entered at "COST": added IF done; exit
Compressed purch report total cost inaccurate due comm fixed by
totaling comm then divide by tot shrs; replace comm in temp
(Getdate) Intermittent error if illegal date entered. Broke
dates tomonth, day, year; test each individually.
Acct summary went to new page - added PROW() test to check page
(Getrecd) - error, more then 60 securities went off scr; fixed
---- March 1992 - version 3.4
Added color change name to first screen on startup
Added color change to closing phrase IF NOT registered
Removed TIMEOUT 30 from options in EXIT menu
Changed cost of program to $45.00: source to $26.00
Added "restore from pmmemory" to "recover hld" routine. Also
added "return to pmstart" to active recovered "hld" files
PAGE 98
---- March 1992 - version 3.4 - (continued)
Added 800 number to program for registration
On goodby screen dropped color change to B & W (left set color)
(Ckprtoff) ERROR if all repts added to existing disk file
rept. Added !all_file to proc (stops write loop until
rept is done)
(Getinc) ERROR: had EXIT but not in loop - changed to RETURN
If purchase opt 2 selected, stk selected then "NO" to correct
stk then another (or same) stk selected the "AVG COST" is
inaccurate. Corrected by moving set values to 0 inside
loop. NO harm to perm data.
If "return to select", redo not reset to .F. causes exit
from subsequent entry before posting. Put "redo=.F."
inside the loop.
Added comma to "is it tax deferred" Y/N question (line 287)
Error produced if div added to sold stock. Test for 0 in
avg (cost) and tshrs. Block divide if 0. Caused divide
by 0 error.
Added bkramt1 > 0 to test if amount was entered to be posted
to the broker records. Before if "YES" then 0 entered
full amt posted.
When covering short pos bkr slip needs to subtract comm.
Added 'on key F2 do nocalc" to disable calc in bonus programs.
It caused the prg to lockup if calc called from other
bonus programs.
Added "TYPE WITH ntype" to sold DBF if purchase short pos.
When short position fully sold it did not clear the SHRS
field. Added "REPLACE SHRS WITH 0, TYPE WITH ' '".
Cost to val rept (opt 8/opt 5) did not pause on full scr-fixed.
---- September 1992 - version 4.0
Portfolio manager completely re-written to incorporate
suggestions from registered users. Released to Beta test
sites. See the file "PM-FEATU.DOC" on disk # 1 of
distribution disks for an expanded listing of all the changes
made to PM during the current upgrade. Version 4.0 was not
released to distributors due to many suggested changes.
---- October 1992 - version 4.1
The following changes made due to input from Beta test sites.
Create a "HLD" after conversion to 4.x- if not done and "HLD"
is recalled, data mis-match error will occur.
When accts selected, the report did NOT show any sold stk
from the acct. Added loop thru sold recds to add to array.
Changed _plineno var to 58 from 60 lines (prt page length)
New feature - Print a report that was originally sent to disk.
Replace menu numlock feature with a mouse sensitivity
speed control feature. Added new variable mmMOUSE default 5
Added mouse control to Yesno proc. Used mdown(). (SM-1162)
Changed window size on Ask_ok proc to allow shadow on Y/N (SM)
Added ability to print/disk the percent report (SM-1162)
If exit/ESC with no change, go to PMSTART to reset colors (SM)
opt 5 if neg amortization- set error trap err #58 (RK)
PAGE 99
---- October 1992 - version 4.1 - (continued)
Misc opt 10, if ESC used at "new name" request, the
variable "opt8" missing. Set opt8 to 3 in line 6 (RK-1013)
Window title on short sale change to show short sale (RK)
Incorrect picture format (lines 52 & 85) chg . to , (RK)
Changed wording on the error screen about sending me err file.
Bkr rept - skipped page number because of pge=pge+1 entered
twice. Deleted this line at line 7 in program.
Many changes to improve pagination. Main change - created
ck_pageP in prg to handle paging for purch/value/sales.
Fixed spacing on "Paper gain for acct" If () pushed column over
Changes to improve pagination. Kept PROC in program (ck_pageD)
Fixed pagination - put separate paging (ck_pageR) in prg.
Version number changed in screen creation routine
---- December 1992 - version 4.2
Most changes for version 4.2 were with report presentation and
controls for selection of a laser printer in the configuration
program.
Option 5 rewrite to single column and added print option (1211)
If user has only ONE acct, all repts that allow acct
selection are NOT shown. Assigned the acct name to the var
"wh_acct" in line 42. This var is used in search loops. (1186)
Add module (opt F) to clear all data files - reset memory var
Added "RETURN OF CAP" prog instructions starting at line 475
Added mmLASER to new variable list. Added separate test for
new var. If exist show notice and initialize to .F.
(Yesno) Test for mouse position if used for yes/no response.
Changed ALL specific page lengths to var pge_len to
work with assigned page length depending on type printer.
Added "to_scr" test just before summary to stop page eject
Added "IF to_scr" after current ROI - maintain proper line cnt
Added a test to see if enough disk space for backup to floppy
---- January 1993 - version 4.3
Changed version number to reflect changes in some screens and
documentation to reflect new membership in the Association of
Shareware Professionals (ASP)
Blocked seeing BONUS menu if not registered (ASP - required)
Changed wording in registration request on opening scr (ASP)
3.E.a SPECIAL NOTE TO HISTORY
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Why all the above ????? The main reason is to show you, the
potential REGISTERED user, that Portfolio Manager has been
supported in the past and, hopefully, to assure you it will
continue to be supported in the future.
*** Lotus 123 is a registered trademark of Lotus corp.
*** Foxbase+ & Foxpro are registered trademarks of Fox Software.
PAGE 100
3.F G L O S S A R Y
~~~~~~~~~~~~~~~
The following is a list of some terms used in the program,
the help screens, and this manual.
PM: Portfolio Manager
MPM: Multiple Portfolio Manager - A module sold separately to
manage multiple portfolios. See Opt # 7 in the EXIT menu.
FUNCTION: ROUTINE: OPTION: MODULE:
Used interchangeably to refer to a menu option that
performs a specific task in the program.
The following is a brief explanation of data files:
DATABASE: Group of records with related information. Think of
or FILE it as a drawer in a file cabinet. Five data files
PMPURCH.DBF, PMDIV.DBF, PMSOLD.DBF, PMBROKER.DBF, PMDIVOLD.DBF
RECORD: Group of FIELDS with information on a single item.
Think of it as a file folder within a file drawer.
FIELD: A single piece information within a record. An
individual page within the file folder.
Example:
Best Stock Inc | 07/15/92 | 100 | 10.00
The line above is a record.
Each data item between the "|" marks is a field.
A group of these lines (records) would be a database.
INDEX FILE: Allows for a quick search for a particular record;
like the labels on file folders. Five index files:
PMPNUM.IDX, PMNAME.IDX, PMBOTH.IDX, PMSNUM.IDX, PMDNUM.IDX
MEMORY FILE: A collection of stored or user set variables such
as account names, portfolio value, user name, etc.
The memory file is named PMMEMORY.MEM
The following is a brief explanation of DOS terminology:
Dr: = disk drive (a location in the computer where information
is stored) ( A:>, B:>, C:>, etc.).
filename (F/N) = name used for examples where you substitute
the actual name for the example name.
Root directory = the main or top-most directory of a hard
disk drive.
Sub-directory (Subdir) = a division of a drive created to hold
a specific group of programs.
File = a grouping accessed by the computer as a complete unit.
Each file has its own directory entry. Throughout the
documentation for PM, files are often referred to as
data files (hold the data you entered) or program files
(contain the commands needed to make the program work).
File Extension = the letter (or numbers) following the period
in a filename.
ie. MANUAL.DOC - "DOC" is the file extension
